JOIN

  • Updated

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)