How to add text cells together into one cell in Excel?

Sometimes, you need to combine text cells into one cell for a specific purpose. In this article, we will show you two methods to add text cells together into one cell in Excel with details.

Add text cells together into one cell with formula
Add text cells together into one cell with Kutools for Excel

Add text cells together into one cell with formula

You can add text cells together into one cell with formula. Please do as follows.

1. Select a blank cell (says cell C2) adjacent to the cells you want to add together, then enter the formula =A2&" "&B2 into the Formula Bar, and press the Enter key.

Note: In the formula, A2 and B2 are the cells you want to combine together; and " " means that the combined texts will be separated by space. You can change the cell references as well as separator as you need.

2. Keep selecting the Cell C2, drag the Fill Handle down to the cells you need to apply the formula. See screenshot:

Then the text cells are added together into one cell.

Add text cells together into one cell with Kutools for Excel

The Combine Rows, Columns or Cells without Losing Data utility of Kutools for Excel helps to easily add text cells together into one cell in Excel. Please do as follows.

1. Select the range with text cells you need to add together, then click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data. 

2. In the Combine Rows, Columns or Cells without Losing Data dialog box, you need to:

You can see the text cells are added together into one cell as below screenshot shown.