JOIN

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

Syntax

=JOIN(array, separator)

Argument	Type	Description
array	Array	Array of elements to convert to a string
separator	String	String separator to use when combining elements

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

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

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

Updated 9 months ago