TEXTJOIN
Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
Parameters
- delimiter: Required. A text string to insert between each combined text value
- ignore_empty: Required. If TRUE, ignores empty cells
- text1: Required. Text item to be joined
- text2: Optional. Additional text items, up to 252
Example
=TEXTJOIN(", ", TRUE, A1:A5)