Excel TEXTJOIN function

Function              TEXTJOIN

Description        Excel TEXTJOIN function combines 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.

Syntax  TEXTJOIN (delimiter, ignore_empty, text1, [text2], …)

delimiter  Separator between each text.

ignore_empty  Whether to ignore empty cells or not.

text1  First text value or range.

text2  [optional] Second text value or range.

Example:

Here I am applying the TEXTJOIN function an array of text and number values. I have put the delimiter as “-” and 1 for ignore_empty.

Let’s keep one cell in the array empty.

And I shall put 0 in the place of ignore_empty.

Excel TEXTJOIN function

This is including the empty cell also.

Excel TEXTJOIN function

Now let’s put 1 in the place of ignore_empty

Excel TEXTJOIN function

Now, this does not include empty cells.