Using the Ampersand symbol, which you can enter with Shift+7, is the simplest way of joining cell contents. In the following example, we'll use =A2&" "&B2 to join first and last names.
1. Click the cell where you want to put the combined text.
2. Type =, then click the cell that contains the first text you want to combine, such as a person’s first name.
3. Type &” “& (a space enclosed in quotation marks).
4. Click the next cell with the text that you want to combine, such as the person’s last name, then press Enter.
TIP: To combine the text from more than two cells, continue selecting cells, and typing &” “& after each cell you select. If you don’t want to add a space between the combined text, type & instead of &” “&. To add a comma, type &”, “& (a comma followed by a space, both enclosed in quotation marks).