Combine the Contents of Multiple Cells in Excel

Question

How to combine contents of multiple cells in Excel?

Answer

You can use a formula with the ampersand (&) operator to combine text from multiple cells into one cell.
  1. Select the cell in which you want to combine the contents of other cells.
  2. To start the formula, type =(
  3.  Select the first cell that contains the text that you want to combine, type &" "& (with a space between the quotation marks), and then select 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 &" "& between selections. If you don't want to add a space between combined text, type & instead of &" "&. To insert a comma, type &", "& (with a comma followed by a space between the quotation marks).
  4. To finalize the formula, type )
  5. To see the results of the formula, press ENTER.

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.