Skip to main content

How to combine the contents of multiple cells into one in Excel?

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.
4. 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).
5. To finalize the formula, type )
6. To see the results, press Enter.

You can use formula called “Concatenate” for doing the same task as shown above.
For example type something in A5 and B5. And click on cell A6. Type the following formula in it and see the result.

=CONCATENATE(A5,B5).

Happy Excelling.

Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.

Comments