Combine text from multiple cells or ranges with a delimiter between each item.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)Arguments
delimiterrequired
The separator placed between items, e.g. ", ".
ignore_emptyrequired
TRUE to skip blank cells.
text1…required
The values or ranges to join.
TEXTJOIN concatenates a range of values and inserts a delimiter — a comma, space, or line break — between them, optionally skipping blanks. It's far cleaner than chaining CONCAT or & for lists. Available in Microsoft 365 and Excel 2019+.
=TEXTJOIN(", ", TRUE, A2:A6)→Mon, Tue, Wed, FriJoins the list with commas and skips the empty cell.
Choose a delimiter
Decide the separator — ", ", a space, or CHAR(10) for line breaks.
Decide on blanks
Set ignore_empty to TRUE to drop empty cells from the result.
Point at the range
Pass a whole range instead of individual cells.
TEXTJOIN adds a delimiter between items and can skip blanks; CONCAT simply glues values together with no separator.