calc give a value a name?

users
#1

Hi All,
I have a project in calc that uses 2 sheets 1 data 2 ladder

here is what one entry looks like on data A5 1. B5 J Beckman C5 3.916

here is a enrty for the latter sheet where it is displayed =CONCATENATE(data.A5, " ", data.B5," ",data.C5)

here is my question in place of A B and C can i give each a name like pos name and et if so how?
and now would it change =CONCATENATE(data.A5, " ", data.B5," ",data.C5) ?
thanks

#2

Greetings,
You can name ranges and use that name in a formula. To name a range, highlight the range, and place its name in the top left area where the data range is shown (this area usually shows the coordinates of the cell(s) where the cursor is). For example, in your case, your data seems to be placed by columns. I would create 3 named ranges: one for each column A, B, and C. I would start by highlighting the entries in column A then set the name of that range to ID; I would do the same for column B and then set the name to NAME; and then SCORE for column C.
The formula on the second sheet would then become =CONCATENATE(ID;" ";NAME;" ";SCORE).
I hope this helps.
Rémy Gauthier.