TEXTJOIN
Combines text from multiple ranges or strings, inserting a specified delimiter between each text value.
Syntax
 Copy Code
|
|---|
TEXTJOIN( Text delimiter, Logical ignore_empty, Any text1, Any text2, ... ) → String |
delimiter | Required. A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. |
ignore_empty | Required. If TRUE, empty cells are ignored. |
text1 | Required. Text items to be joined. A string or array of strings, such as a range of cells. |
text2 | Optional. Additional text items to be joined. |
Function Reference
INDEX Function
MATCH Function
OFFSET Function
HLOOKUP Function