These docs are for v1.0. Click to read the latest docs for v1.2.

JOIN

Creates a string from array elements connected by a specified separator.

Syntax

=JOIN(array, separator)

Arguments

ArgumentTypeDescription
arrayArrayArray of elements to convert to a string
separatorStringString separator to use when combining elements

Examples

=JOIN([1, 2, 3], "_")"1_2_3"

=JOIN(["A", "B", "C"], "")"ABC"

=JOIN([], ", "])""