Embedded Files
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
How to use?
How to use?
SYNTAX: =JOIN(delimiter, value_or_array1, [value_or_array2, ...])
delimiter - The character or string to place between each concatenated value.
delimiter may be specified as blank, e.g. JOIN(,{1,2,3}).
value_or_array1 - The value or values to be appended using delimiter.
value_or_array2, ... - [ OPTIONAL ] - Additional value or array to be appended using delimiter.
PRACTICE SHEET
The below sheet is view only mode, please make a copy to practice.
Page updated
Google Sites
Report abuse