• Updated

Combines the elements of one or more one-dimensional arrays using a specified delimiter.

Sample Usage



TEXTJOIN(delimiter, ignore_empty, array1, [array2,..])

  • delimiter - The character or string to place between elements of different arrays. 
  • ignore_empty - If set to TRUE, empty cells selected in the text arguments won't be included in the result.
  • array1 - Text item(s) to be joined. 
  • array2,.. - [OPTIONAL] Additional text item(s) to be joined.  


TEXTJOIN(",",TRUE, C5:C7) returns the combined elements from C5:C7, separated by a comma. 


  • When delimiter is omitted, the result of TEXTJOIN is similar to that of CONCATENATE.
  • delimiter may be specified as a blank space. For example, TEXTJOIN(" ",TRUE, C5:C7)