Text
Modern
TEXTJOIN
Joins text from multiple ranges with a delimiter, optionally skipping empty cells.
Available in Microsoft 365 · Excel 2024 · Excel 2021 · Excel 2019 · Excel for the web. Not in Excel 2016 or earlier.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, ...)What it returns
A single text string of all items joined by the delimiter.
Arguments
| Argument | Required | Description |
|---|---|---|
delimiter |
Yes | The character(s) inserted between each item (e.g. ", "). |
ignore_empty |
Yes | TRUE to skip empty cells, FALSE to keep them. |
text1 |
Yes | The first text item or range to join. |
… |
No | Additional text items or ranges (up to 252). |
Example
Paris+Lyon+Nice
Result
Paris, Lyon, Nice
TEXTJOIN joins items with a delimiter between each (here a comma and a space).
=TEXTJOIN(", ", TRUE, A2:A5)Important to know
ignore_empty=TRUE avoids double delimiters from blank cells.
Not available in Excel 2016 or earlier.