Constructing Reality...

Excel How-To

How to Combine Text in Excel (CONCAT / TEXTJOIN)

Use & or CONCAT to glue cells together, or TEXTJOIN when you need a delimiter and want to skip blanks.

Do it with AI instead

Step by step

1
Pick a method
Use & for quick joins, TEXTJOIN for a delimiter across a range.
2
Write the formula
For example =TEXTJOIN(", ", TRUE, A2:C2) joins three cells with commas.
3
Fill down
Drag the fill handle to apply the formula to the whole column.

=TEXTJOIN(", ", TRUE, A2:C2)

FAQ

What's the difference between CONCAT and TEXTJOIN?

TEXTJOIN adds a delimiter and can ignore empty cells; CONCAT just sticks everything together.

Related guides

How to Split Text into Columns in Excel How to Use VLOOKUP in Excel

Keep exploring

Functions

CONCAT TEXTJOIN LEFT MID