JOIN (STRING)
Joins two or more text values with a separator in-between.
Syntax
JOIN(separatorString, value1, value2, ...)
Example
join(':::', ‘A’, ‘B’, ‘C’)returns A:::B:::C
Notes
Like concat() but uses the first argument as a separator.
JOIN(separatorString, value1, value2, ...)
join(':::', ‘A’, ‘B’, ‘C’)returns A:::B:::C
Like concat() but uses the first argument as a separator.