Arguments
delimiter- The separator placed between items, e.g. ", ".ignore_empty- TRUE to skip empty cells, FALSE to keep them.text1- The first text item or range to join.
TEXTJOIN
Joins text from multiple cells or a range with a delimiter, optionally skipping blanks.
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)=TEXTJOIN(", ", TRUE, A2:A10)Returns: A comma-separated list of the non-blank values
Great for turning a column into one cell.
Common Errors and Gotchas
- #NAME? means your Excel version is older than 2019 - concatenate with & instead.
- Set ignore_empty to TRUE to avoid doubled-up delimiters from blank cells.
Does TEXTJOIN Work in Google Sheets?
Yes. TEXTJOIN uses the same syntax in Google Sheets and LibreOffice Calc, so you can paste these formulas straight across.
Build a TEXTJOIN formula
Fill in your ranges and copy a ready-to-paste formula - no signup.