Text Manipulationbeginner
TEXTJOIN a column into one cell
=TEXTJOIN(", ",TRUE,A2:A20)
Function reference
TEXTJOIN in Excel & Google Sheets
TEXTJOIN is used in 2 formula patterns in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
2 beginnerBuild a custom TEXTJOIN formula →
When to use TEXTJOIN
- Create a summary field that lists all items, names, or tags from a column without manual copy-pasting.
- Merge name parts from separate columns while skipping blanks automatically.
Worked examples (2)
Text Manipulationbeginner
TEXTJOIN for full name building
=TEXTJOIN(" ",TRUE,A2:C2)
Common errors with TEXTJOIN
#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.
Extra separators appear
Make sure the ignore-empty argument is TRUE so blank cells do not create unwanted spaces.
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.
Can TEXTJOIN handle blank middle names?
Yes. With TRUE as the ignore-empty argument, blank cells are skipped automatically.
Need a custom variation?
Describe your specific TEXTJOIN problem and get a formula written for your exact data.
Open generator with TEXTJOIN