TEXTJOIN

  • Updated

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

Sample Usage

TEXTJOIN(",",C5:C7)

Syntax

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.  

Examples

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

Notes

  • 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)