what is the "&" used for in excel

[John]

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

 

[Gord Dibben]

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