Joining text together easily
By Neale Blackwood
To join text strings together you use the & symbol. If cell A1 contained John and A2 had Smith then the formula =A1&A2 would display JohnSmith to insert a space between the name you would use = A1&” “&A2. Note : there is a space between the inverted commas.
There is a function called CONCATENATE that performs the same task. In the above example the formula would be =CONCATENATE(A1,” “,A2).
Most users just use & symbol as it involves less typing.