Combines the elements of one or more one-dimensional arrays using a specified delimiter.
Sample Usage
JOIN(",",C5:C7)
Syntax
JOIN(delimiter, array1, [array2,..])
- delimiter - The character or string to place between elements of different arrays.
- array1 - Text item to be joined.
- array2,.. - [OPTIONAL] Additional text items to be joined.
Examples
JOIN(",",C5:C7) returns the combined elements from C5:C7, separated by a comma.
Notes
- When delimiter is omitted, the result of JOIN is similar to that of CONCATENATE.
- delimiter may be specified as a blank space. For example, JOIN(" ",C5:C7)