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.
Joins a range with a delimiter, optionally skipping blanks. Requires Excel 2019/365; accepts whole ranges unlike CONCATENATE.
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.
| Expression | Result | Why |
|---|---|---|
| =TEXTJOIN(", ",TRUE,A2:A5) | Excel, Formula, Lookup, Lab | Join a range with a comma-space delimiter |
| =TEXTJOIN("-",TRUE,A2:A3) | Excel-Formula | A hyphen delimiter |
| =TEXTJOIN("",TRUE,A2:A3) | ExcelFormula | Empty delimiter joins with no gap |
| =TEXTJOIN(" | ",TRUE,A2,B2) | Excel | 101 | Mix text and a number with a pipe |
| =TEXTJOIN(",",TRUE,"a","","b") | a,b | ignore_empty TRUE skips the blank |
| =TEXTJOIN(",",FALSE,"a","","b") | a,,b | ignore_empty FALSE keeps the blank |
| =TEXTJOIN("-",TRUE,A2:A5) | Excel-Formula-Lookup-Lab | Every cell joined with a hyphen |
| =TEXTJOIN(",",TRUE,A2:A5) | Excel,Formula,Lookup,Lab | A bare comma delimiter |
| Expression | Result | Why |
|---|---|---|
| =TEXTJOIN(", ",FALSE,A2:A5) | Excel, Formula, Lookup, Lab | No blanks here, so FALSE looks the same |
| =TEXTJOIN(CHAR(10),TRUE,A2:A3) | Excel⏎Formula | CHAR(10) makes a line-break delimiter |
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.
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.
TEXTJOIN requires Excel 2019 or Microsoft 365 (and Excel Online). It is not available in Excel 2016 or earlier.
| Platform | Support | Notes | Gotcha |
|---|
TEXTJOIN is one piece. The full course walks the toolkit end to end with live, measured examples.