TEXTJOINCombines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.
Sample Usage
TEXTJOIN(“ “, TRUE, “hello”, “world”)
TEXTJOIN(“, ”, FALSE, A1:A5)
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2, …])
delimiter – A string, possibly empty, or a reference to a valid string. If empty, text will be simply concatenated.
ignore_empty – A boolean; if TRUE, empty cells selected in the text arguments won’t be included in the result.
text1 – Any text item. This could be a string, or an array of strings in a range.
text2, … [OPTIONAL] – Additional text item(s).
See Also
JOIN: Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
CONCATENATE: Appends strings to one another.
Example
A
B
1
Data
2
Hello
3
there
4
5
6
Sheets
8
Result
Formula
9
Hello there Sheets
=TEXTJOIN(” “, TRUE, A2:A6)
10
Hello there Sheets
=TEXTJOIN(” “, FALSE, A2:A6)