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.