TEXTJOIN

Combine the text from multiple ranges/arrays using a delimiter. It can ignore empty cells.

Parameter List

Syntax
TEXTJOIN(delimiterignore_emptytext1
[text2, …]
)
delimiter

The separator to use between text items. For example: ,, -, or a space.

ignore_empty

A Boolean indicating whether to ignore empty cells. Use TRUE to ignore, FALSE to include.

text1

The first text item, range, or array to be joined. For example: A1:A3.

[optional] text2, …

Additional text items, ranges, or arrays to concatenate. Optional.

Examples

TEXTJOIN(",", TRUE, A1:A5) returns Apple,Banana,Cherry