TEXTJOIN
Joins multiple texts and lists of text into a single text, placing a delimiter between
Usage
TEXTJOIN(delimiter, ignore_empty, text_or_list...)
Parameters
delimiter |
(Required) What to place between each piece of text |
ignore_empty |
(Required) Give |
text_or_list |
(Required) A text, anything that can be displayed, or a list of such values. If a list, each element of the list are joined by the delimiter |
... |
Many text_or_list can be joined with one another |
Examples
More information
The [
and ]
mark the beginning and end of a list.