Name

join — Join elements of a list to form a string.

Syntax

join(list, delimiter)
              

The JOIN function has the following arguments:

list

A list containing the elements to be joined.

delimiter

The character or string to place between each concatenated value.

Description

Concatenate the elements of a list with the delimiter inserted between each element. The result is returned as a string.

Examples

Formula

Description

Result

join({'a','b','c'},',')Return the list elements separated by commas'a,b,c'
join({'a','b','c'},'')Return the list elements joined together'abc'
join({1,2,3},'+')Return the list elements converted to string values and joined by the plus symbol.'1+2+3'