Print
Print:
Body
Combine the Content of Multiple Cells in Excel
Body
Select the cell in which you want to combine the contents of other cells.
To start the formula, type
=(
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).
To finalize the formula, type
)
To see the results of the formula, press
ENTER.
Details
Details
Article ID:
10499
Created
Fri 1/19/24 5:07 PM