Text Manipulationbeginner
TEXTJOIN for full name building
=TEXTJOIN(" ",TRUE,A2:C2)
Excel how-to guide
How to textjoin combine list in Excel
Create a summary field that lists all items, names, or tags from a column without manual copy-pasting.
Step-by-step instructions
How to textjoin combine list — 3 steps
1
Enter the delimiter you want between values, such as a comma and space, as the first argument.
2
Set the second argument to TRUE so blank cells are skipped automatically.
3
Select the range that contains the values you want to combine.
Example data
Worked example
| Tag |
|---|
| Excel |
| Pivot |
| VLOOKUP |
| Dashboard |
Common mistakes
Errors to watch out for
#NAME? error
TEXTJOIN requires Excel 2019 or Microsoft 365. Use CONCATENATE with & for older versions.
Result includes unwanted blanks
Make sure the second argument is TRUE so TEXTJOIN skips empty cells in the range.
FAQ
Frequently asked questions
Can I use a line break as the delimiter?
Yes. Use CHAR(10) as the delimiter and enable Wrap Text on the result cell to display each value on its own line.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides