TEXTJOIN

TextExcel 2019

Join a list with a delimiter, optionally skipping blanks.

Syntax

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Arguments

delimiter: Put between each item, e.g. ", " or CHAR(10) for a line break.
ignore_empty: TRUE skips empty cells so you don't get double delimiters.
text1 …: Values or ranges to join.

Examples

=TEXTJOIN(", ", TRUE, A2:A6)

→ Red, Green, Blue

=TEXTJOIN(" / ", TRUE, B2:D2)

→ S / M / L

Related functions

CONCAT TEXTSPLIT

More Text functions

ARRAYTOTEXT ASC BAHTTEXT CHAR CLEAN CODE CONCAT CONCATENATE DBCS DOLLAR EXACT FIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.