Combines 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; ifTRUE, 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) |
