Excel TEXTJOIN Function
TEXTJOIN combines text values with a delimiter between each item.
Use it to build comma-separated lists, readable labels, ID strings, names, or summaries from ranges while optionally skipping blank cells.
TEXTJOIN syntax & arguments
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
-
1
delimiter
RequiredThe text to place between joined values, such as a space, comma, hyphen, or empty string.
-
2
ignore_empty
RequiredControls whether blank values are skipped while joining:
TRUE— Ignore blanks: Skips blank cells and empty text values so extra delimiters are not inserted for them.FALSE— Keep blanks: Includes blank positions, which can create repeated delimiters when source values are empty.
-
3
text1
RequiredThe first text value, cell reference, range, or formula result to join.
-
4
text2
Optional RepeatableAdditional text values, cell references, ranges, or formula results to append in order.
Example
=TEXTJOIN(", ", TRUE, A2:A10)
Join non-empty values from A2:A10 with a comma and space between each value.
TEXTJOIN caveats
-
The delimiter is inserted between items only
TEXTJOIN does not add a delimiter before the first item or after the last item.
-
The result has a cell length limit
Very large joins can exceed Excel's maximum cell text length and return an error.
Joining a few fixed pieces? CONCATENATE works for simple ordered pieces, while TEXTJOIN is usually cleaner for ranges or delimiter-based lists.
Intro TEXTJOIN practice problem
Solve the intro problem directly here, or open it on its own page.
Advanced TEXTJOIN practice problems
Use TEXTJOIN alongside other Excel functions in realistic, less-prescriptive challenges.
