Excel TEXTJOIN function
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.
This is including the empty cell also.
Now let’s put 1 in the place of ignore_empty
Now, this does not include empty cells.