Excel TextJoin
The TEXTJOIN function concatenates values.
Description
This function was added in Excel 2019 and Office 365. For legacy systems, use CONCATENATE.
Usage
The arguments for this function are:
=TEXTJOIN(DELIMITER, IGNORE_EMPTY, VALUE, [VALUE, ...])
A delimiter is inserted between every value. If set to "", this function is more or less equivalent to CONCAT.
Order of Ranges
Given the following worksheet:
|
A |
B |
1 |
a |
b |
2 |
c |
d |
The formula =TEXTJOIN(" ",TRUE,A:A,B:B) would return a c b d, while the formula =TEXTJOIN(" ",TRUE,A1:B2) would return a b c d.
Variable Delimiters
Given the following worksheet:
|
A |
B |
C |
1 |
a |
b |
c |
2 |
d |
e |
f |
3 |
end |
|
|
4 |
, |
, |
; |
The formula =TEXTJOIN(A4:C4,TRUE,A1:C3) would return a,b,c;d,e,f;end.