JOIN

Joins a list of texts

Description

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

Function signature

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

Parameter

Description

Values

List of text values

Separator

Separator for texts

Examples

Formula

Return value

JOIN(["a", "b", "c"], ", ")

a, b, c

JOIN([], "")

''