TextJoin formula

SYNTAX: =TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])

delimiter - A string, possibly empty, or a reference to a valid string. If empty, text will be simply concatenated.

ignore_empty - A boolean; if TRUE, empty cells selected in the text arguments won't be included in the result.

text1 - Any text item. This could be a string, or an array of strings in a range.

text2, ... [OPTIONAL] - Additional text item(s).