Tip 269 – Join text using the ampersand

If you have a column containing first names and another column containing surnames and you could like to join the two together so the full name is in the same column or cell, in a third empty column, on the first row, enter this formula: =A2&” “&B2, where A2 is the cell with the first name, and B2 is the cell with the surname – modify as required, or use =B2&”, “&A2 if you wish to display the surname, followed by a comma and then the first name.