what is the "&" used for in excel
 

what is the "&" used for in excel
 

Hi Graham
It's used to concatenate text or multiple cells.
e.g. A1&B1, will combine the information from the two cells into one.
HTH
John
"Graham" wrote in message
...

what is the "&" used for in excel
 

Can be used for many operations but generally used to combine two cells like

=A1&B1 or =A1&" "&B1

Or any text operation like

="This is your salary. " & Text(B1,"$#,##0") & " For the month of February"

Where B1 conatins a number like 123,456


Gord Dibben MS Excel MVP


On Thu, 18 Feb 2010 11:53:01 -0800, Graham
wrote: