Combines several text items into one, accepts cell ranges as arguments. Uses delimiter between items.
= TEXTJOIN(delimiter, ignore_empty, value[, ...])
delimiter - Text string to be used as delimiter.
ignore_empty - If TRUE, empty cells are ignored.
value - Text and/or cell ranges for the concatenation.