Microsoft Excel 2016 – Combine the contents of multiple cells

You can use the ampersand (&) operator in a formula to combine text from multiple cells into one cell, such as a first name and a last name.

Here’s what you do:

Click the cell where you want the text string to appear.

To start the string, type =(.

To combine the contents of two cells, click the first cell that contains the text that you want to combine, type &" "& (a space enclosed in quotation marks), and then click the next cell that contains the text that you want to combine.

To combine the contents of more than two cells, continue selecting cells, making sure to type &" "& after you select each cell.

If you don't want to add a space between combined text, type & instead of &" "&.

To insert a comma, type &", "& (a comma followed by a space, both enclosed in quotation marks). 

To complete the formula, type ) and, finally, to see the results of the formula, press ENTER.