Function 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 `TRUE` to skip empty pieces of text. This avoids having 2 consecutive delimiters, for example. Give `FALSE` otherwise.
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

Example	With these variables	Result
TEXTJOIN(“, “, TRUE, particularities)	particularities is ["multi-user", "performant", "efficient"]	“multi-user, performant, efficient”
TEXTJOIN(“, “, TRUE, participants, “Greg”, “”, 42)	participants is ["Max", "Jack", "Anna"]	“Max, Jack, Anna, Greg, 42”
TEXTJOIN(“, “, FALSE, participants, “Greg”, “”, 42)	participants is ["Max", "Jack", "Anna"]	“Max, Jack, Anna, Greg, , 42”

More information

The [ and ] mark the beginning and end of a list.