Articles with the tag:
Articles with the tag:
Try in the cloud


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.


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.


How to apply the TEXTJOIN function.


The figure below displays the result returned by the TEXTJOIN function.


Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action