Text · join with delimiter · Nov 2026

The TEXTJOIN function,
measured & explained.

Syntax, a live playground, a measured delimiter gallery, the ignore_empty switch and version trap, and a sourced error library: joining a range with a delimiter.

D1
fx
=TEXTJOIN(", ", TRUE, A2:A5)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How TEXTJOIN works

Joins a range with a delimiter, optionally skipping blanks. Requires Excel 2019/365; accepts whole ranges unlike CONCATENATE.

=TEXTJOIN(delimiter, ignore_empty, text1, [...])
delimiterThe separator — required; can be "" or CHAR(10).
ignore_emptyTRUE skips blanks; FALSE keeps them.
text1...A range or list of items to join.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Join with a delimiter

What TEXTJOIN actually builds

TEXTJOIN joins a range with a delimiter you choose, and ignore_empty decides whether blanks are skipped. It is the modern, range-aware join. Every row was measured live in HyperFormula. Click any row to load it.

Delimiter gallery — ignore_empty TRUE vs FALSE

ExpressionResultWhy
=TEXTJOIN(", ",TRUE,A2:A5)Excel, Formula, Lookup, LabJoin a range with a comma-space delimiter
=TEXTJOIN("-",TRUE,A2:A3)Excel-FormulaA hyphen delimiter
=TEXTJOIN("",TRUE,A2:A3)ExcelFormulaEmpty delimiter joins with no gap
=TEXTJOIN(" | ",TRUE,A2,B2)Excel | 101Mix text and a number with a pipe
=TEXTJOIN(",",TRUE,"a","","b")a,bignore_empty TRUE skips the blank
=TEXTJOIN(",",FALSE,"a","","b")a,,bignore_empty FALSE keeps the blank
=TEXTJOIN("-",TRUE,A2:A5)Excel-Formula-Lookup-LabEvery cell joined with a hyphen
=TEXTJOIN(",",TRUE,A2:A5)Excel,Formula,Lookup,LabA bare comma delimiter

The ignore_empty switch

ExpressionResultWhy
=TEXTJOIN(", ",FALSE,A2:A5)Excel, Formula, Lookup, LabNo blanks here, so FALSE looks the same
=TEXTJOIN(CHAR(10),TRUE,A2:A3)Excel⏎FormulaCHAR(10) makes a line-break delimiter
⚠ TEXTJOIN needs Excel 2019 or 365 — older Excel returns #NAME?. ignore_empty=TRUE skips blank cells; FALSE keeps them, producing double delimiters. The delimiter can be any string, even CHAR(10) for a line break. Unlike CONCATENATE, TEXTJOIN accepts a whole range.
// 03 — Try it live

Interactive TEXTJOIN playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see TEXTJOIN join a range with commas, hyphens, or pipes, and skip or keep blanks via ignore_empty.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where TEXTJOIN works

TEXTJOIN requires Excel 2019 or Microsoft 365 (and Excel Online). It is not available in Excel 2016 or earlier.

PlatformSupportNotesGotcha
✓ Supported full TEXTJOIN◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master delimiter joining

TEXTJOIN is one piece. The full course walks the toolkit end to end with live, measured examples.

  • TEXTJOIN vs CONCATENATE vs CONCAT
  • ignore_empty and the double-delimiter trap
  • Line-break delimiters with CHAR(10)
  • Version fallbacks for Excel 2016 and earlier
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked