TEXTJOIN Function Generator
TEXTJOIN joins text values with a delimiter you choose, and can skip empty cells automatically. The modern replacement for CONCATENATE when building comma-separated lists.
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])Try it — generate a TEXTJOIN formula
Examples
Comma-separated list
=TEXTJOIN(", ", TRUE, A2:A10)Joins with ", " and skips blanks in the range.
Build a sentence
=TEXTJOIN(" ", TRUE, "Hello", A2, "from", B2)Mixes literal text with cell references.
CSV from row
=TEXTJOIN(",", FALSE, A2:E2)Keeps empty fields (important for CSV alignment).
Tips
- ✓TEXTJOIN handles ranges; CONCATENATE only handles individual cells.
- ✓ignore_empty=TRUE skips empty strings AND empty cells.
- ✓Use CHAR(10) as delimiter for multi-line output (enable Wrap Text on the cell).
Related Formulas
CONCATENATE / TEXTJOIN
Combine text from multiple cells into one. TEXTJOIN is the modern approach with ...
Text Split / Extract
Split text into parts, extract substrings, or parse structured data like email a...
ARRAYFORMULA
ARRAYFORMULA applies a formula to an entire column or range at once, eliminating...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free