TEXTJOIN function
Summary
Combines the text from multiple ranges and/or strings
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
delimiter (required) | A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.
ignore_empty (required) | If TRUE, ignores empty cells.
text1 (required) | Text item to be joined. A text string, or array of strings, such as a range of cells.
[text2, ...] (optional) | Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.
For example, =TEXTJOIN(" ",TRUE, "The", "sun", "will", "come", "up", "tomorrow.") will return The sun will come up tomorrow.
ignore_empty (required) | If TRUE, ignores empty cells.
text1 (required) | Text item to be joined. A text string, or array of strings, such as a range of cells.
[text2, ...] (optional) | Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.
For example, =TEXTJOIN(" ",TRUE, "The", "sun", "will", "come", "up", "tomorrow.") will return The sun will come up tomorrow.
Example
=TEXTJOIN(", ", TRUE, A2:A8)
=TEXTJOIN(", ", TRUE, A2:B8)
=TEXTJOIN(A8:D8, TRUE, A2:D7)
=TEXTJOIN(", ", TRUE, A2:B8)
=TEXTJOIN(A8:D8, TRUE, A2:D7)