TEXTJOIN Function
The TEXTJOIN function is one of the text and data functions. Is used to combine the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined; if the delimiter is an empty text string, this function will effectively concatenate the ranges. This function is similar to the CONCAT function, but the difference is that the CONCAT function cannot accept a delimiter.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
The TEXTJOIN function has the following argument:
Argument |
Description |
delimiter |
The delimiter to be inserted between the text values. Can be specified as a text string enclosed by double quotes (e.g. "," (comma), " " (space), "\" (backslash) etc.) or as a reference to a cell or range of cells. |
ignore_empty |
A logical value that specifies whether empty cells should be ignored. When the value is set to TRUE, empty cells are ignored. |
text1/2/n |
Up to 253 data values. Each value can be a text string or a reference to a range of cells. |
Notes
How to apply the TEXTJOIN function.
Examples
The figure below displays the result returned by the TEXTJOIN function.
Return to previous page