TEXTJOIN

TEXTJOIN: Joins text values using a delimiter, with optional empty-value filtering.

Summary

TEXTJOIN(delimiter, ignore_empty, text1, ...) is useful for building labels and lists.

ignore_empty=TRUE skips empty strings and empty cells.
ignore_empty=FALSE includes empty items, which can produce adjacent delimiters.
Text ranges and arrays are flattened in row-major order.
Delimiter and values are coerced to text.
Any error in inputs propagates immediately.
Results longer than 32,767 characters return #VALUE!.

Ignore empty entries

Grid

Cell	Value
No inputs on Sheet1.

Formula

Result

Not evaluated yet.

Expected

a,c

TRUE skips empty values; FALSE keeps them, which can create adjacent delimiters.