TEXTJOIN
Formula Explanation
The TEXTJOIN function combines text from multiple ranges and/or strings, including a specified delimiter between each text value you want to combine.
If the delimiter is an empty text string, this function effectively concatenates these ranges.
Formula Syntax
Enter in the result column: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
delimiter (required): The text string, or empty, or one or more characters enclosed in double quotation marks, or a reference to a cell containing a valid text string. If a number is provided, it will be treated as text.
ignore_empty (required): If TRUE, it ignores blank cells.
text1 (required): The text items you want to concatenate. These can be text strings, string arrays, or column codes.
[text2, ...] (optional): Additional text items to concatenate. You can have up to 252 text parameters after text1. Each parameter can be a text string, string array, or column code.
The AA1:AA3 notation is not currently supported.
Usage Example
Concatenate column EQ2, EQ3, and EQ4 with "-" as the delimiter, and write the result in column EQ5.
EQ5 = textjoin("-", true, EQ2, EQ3, EQ4)
