|
⇤ ← Revision 1 as of 2022-12-29 13:47:38
Size: 1437
Comment:
|
← Revision 2 as of 2025-04-08 16:58:44 ⇥
Size: 1199
Comment: Cleanup
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| This function becomes available in Excel 2019 and Office 365. For legacy systems, use `CONCATENATE`. See details [[Excel/Concatenate|here]]. | The '''`TEXTJOIN`''' function concatenates values. |
| Line 11: | Line 11: |
| == Description == This function was added in Excel 2019 and Office 365. For legacy systems, use [[Excel/Concatenate|CONCATENATE]]. ---- |
|
| Line 13: | Line 21: |
| CONCAT concatenates a series of 1 or more values into a single string value with a string delimiter. The values can be string values, arrays of string values, or cell ranges. | The arguments for this function are: |
| Line 19: | Line 27: |
| `DELIMITER` is inserted between every string value. If set to `""`, `TEXTJOIN` effectively is the same as `CONCAT`. If `IGNORE_EMPTY` is set to `TRUE`, empty cells will be skipped. This prevents duplicate delimiters from being inserted into the final string. {{{ =TEXTJOIN(", ", TRUE, A2:A8) }}} |
A '''delimiter''' is inserted between every value. If set to `""`, this function is more or less equivalent to [[Excel/Concat|CONCAT]]. |
| Line 29: | Line 31: |
| === Order of Cell Ranges === | === Order of Ranges === |
| Line 31: | Line 33: |
| Given the following table: | Given the following worksheet: |
| Line 43: | Line 45: |
| Given the following table: | Given the following worksheet: |
| Line 52: | Line 54: |
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.