Combine names with ampersand (&)
The ampersand symbol (&) – the one that often represents “And”. Excel takes it as the concatenation tool. If you use it between two cell values, Excel takes it as the command to join together the two cell values🤝
Let me show you here. The image below has two lists of names (the first and the last name).
To combine them, follow these steps:
- Activate the cell where you want the combined name.
- Write in the following formula.
= A2 &
We have referred to the cell that contains the first name (Cell A2).
Next to it is the ampersand😎
- Add a space character enclosed in double quotation marks.
= A2 & “ “
This tells Excel to merge the cell value in Cell A2 with a space character. We’re doing this because we want the first and last name combined with a space character in between.
- Add another ampersand.
= A2 & “ “ &
- Refer to the cell containing the last name i.e. Cell B2.
= A2 & “ “ & B2
With this, we have told Excel to join together the cell value in A2, a space character, and the cell value in Cell B2🚀
P.S: The sequence of values matters.
- Hit Enter to be amazed by the results.
Excel combines the first name (Jane) with the last name (Austin) and there’s a space character in between. Yoo-hoo!
- Drag and drop the results to the whole list of names.