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)