Join

Joins a list of component texts into a single concatenated text, with each component text separated by the optional separator parameter.

JOIN(values: Array, separator: String) => String

Parameter	Description
Values	List of text values
Separator	Separator for texts

Formula	Return value
`JOIN(["a", "b", "c"], ", ")`	`a, b, c`
`JOIN([], "")`	`''`

Was this article helpful?

Table of contents