Re: [libreoffice-users] calc give a value a name?

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 <n9mfk9@gmail.com>
 À : users@global.libreoffice.org 
 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: users+unsubscribe@global.libreoffice.org
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: users+unsubscribe@global.libreoffice.org
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