How to combine the content of two or more cells in Excel

How do you combine the text of multiple cell?

How do you merge the content of two cells?

How do you you combine the content of two columns?


To combine the text of two columns or to combine the cell of two cells into a third cell, enter = A1 & A2 into the third cell.

or use the function = CONCATENATE(A1,A2,....)

You can add other characters in the combination like = A1 & " " & A2 which inserts a space between the two words 

(for formulas, depending on your country, you might have to change ; with , or the opposite

Other excel answers



You can find similar Excel Questions and Answer hereunder

1) How can I sort data using multiple criteria?

2) Applying a countif formula only to visible cells in a filtered list in Excel

3) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?

4) How can I identify cells with Circular Reference in a WorkSheet?

5) How to lock cells so that no one can change them

6) How can I quickly remove all blank cells in a data range?

7) How can I enter information in multiple cells simultaneously?

8) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

9) How can I find the number of working days between 2 dates using VBA?

10) How to see to which cells a cell is connected or used by. How to see the dependents of a cell


Here the previous and next chapter