How to Combine Text from Two or More Cells into One Cell?

You can combine text from two or more cells into one cell using the CONCATENATE function or the “&” operator in Microsoft Excel.

Using the CONCATENATE function:

  1. Select the cell where you want the combined text to appear.
  2. Type “=CONCATENATE(” without the quotation marks.
  3. Select the first cell you want to combine.
  4. Type “,” without the quotation marks.
  5. Select the next cell you want to combine.
  6. Repeat steps 4 and 5 for each additional cell you want to combine.
  7. Type “)” to close the function.
  8. Press Enter to complete the formula.

For example, if you want to combine the text in cell A1, B1 and C1 into cell D1, the formula would be =CONCATENATE(A1,” “,B1,” “,C1)

Using the “&” operator:

  1. Select the cell where you want the combined text to appear.
  2. Type “=” without the quotation marks.
  3. Select the first cell you want to combine.
  4. Type “&” without the quotation marks.
  5. Type “” ” (a space within quotation marks)
  6. Select the next cell you want to combine.
  7. Repeat steps 4, 5 and 6 for each additional cell you want to combine.

For example, if you want to combine the text in cell A1, B1 and C1 into cell D1, the formula would be =A1&” “&B1&” “&C1

Both formulas will combine the text in the specified cells into one cell. Keep in mind that you can use any separator you want (not just space) and you can also add text before or after the combined cells.

How to Combine Text from Two or More Cells into One Cell?
Combine Text from Two or More Cells into One Cell