What TEXTJOIN does
TEXTJOIN combines multiple text values into one result while inserting a separator between items. It is the better choice over CONCAT when you need commas, spaces, line breaks, or when blank cells should be ignored.
Practical examples
Join first and last name with a space
=TEXTJOIN(" ",TRUE,A2:C2)
This is useful for building display names from separate columns such as first, middle, and last name.
Build a comma-separated list from a range
=TEXTJOIN(", ",TRUE,A2:A8)
With TRUE in the second argument, empty cells are skipped so you do not get extra delimiters.
Common mistakes and notes
TEXTJOIN does not add delimiters automatically
If you want commas, spaces, or line breaks between values, they must be supplied in the delimiter argument.
ignore_empty changes the final punctuation
When ignore_empty is FALSE, blank cells still consume a delimiter. That can create doubled commas or extra separators.
Very long joined results can fail
If the final text exceeds Excel's cell length limit, TEXTJOIN returns #VALUE!. That usually shows up when you join very large ranges.