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.
De : Beau Thompson <[email protected]>
À : [email protected]
Envoyé le : jeudi 21 avril 2016 11h09
Objet : [libreoffice-users] calc give a value a name?
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
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
