Text
Join Cells with Separator
Join the contents of multiple cells into a single cell with a custom separator (comma, dash, space, etc.). Modern replacement for the old CONCATENATE function.
Excel Formula
=TEXTJOIN(", ", TRUE, A2:D2)Step-by-Step Explanation
1
TEXTJOIN joins text with a delimiter
2
", " is the separator between values
3
TRUE tells it to skip empty cells
4
A2:D2 is the range of cells to join
5
Much more powerful than CONCATENATE or &
Example
| City (A) | State (B) | Zip (C) | Combined (D) |
|---|---|---|---|
| Tulsa | OK | 74101 | Tulsa, OK, 74101 |
| Dallas | TX | 75201 | Dallas, TX, 75201 |
Result: =TEXTJOIN(", ",TRUE,A2:C2) → Tulsa, OK, 74101
Common Variations
With line breaks
=TEXTJOIN(CHAR(10),TRUE,A2:D2)Each value on new line
Dash separator
=TEXTJOIN("-",TRUE,A2:D2)Join with dashes
Old CONCATENATE
=A2&", "&B2&", "&C2Legacy approach
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →