Parameter List
Syntax
TEXTJOIN(delimiter, ignore_empty, text1,
[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.