| Syntax |
| =TEXTJOIN(delimiter,ignore_empty,text1,[text2}...[text252]) |
| Purpose / Description |
| Returns a text string in which all of the text strings provided are concatenated, allowing the user to specify a delimiter or joining character and whether or not empty text strings should be ignored. |
| Arguments |
| Name |
Type |
Description |
| delimiter |
text string |
A constant, reference or nested expression that returns the delimiter character or string which will be placed between each concatenated entry. |
| ignore_empty |
logical |
A constant, reference or nested expression that provides a flag value that indicates whether empty strings (including those coerced from blank cells) should be ignored and omitted from the result. If omitted, no delimiter is added to the result, if included,a delimiter is added to the result indicating the blank entry in the result text string. |
| text1 |
type |
A constant, reference or nested expression that returns the first string to be concatenated. It may be a reference to more than one cell, and the reference may span worksheets. |
| [text2]...[text252] |
type |
Up to 251 optional extra constants, references or nested expressions that returns other strings to be concatenated. Each one may be a reference to more than one cell, and the references may span worksheets. |
| argument |
type |
description. |
| Return Values |
| Type |
Specific Value |
Description |
| text string |
|
The text string generated by concatenating all the provided values. For multi-cell references, the entries are concatenated by worksheet, by row and by column. Whether or not empty strings are included in the result is controlled by the ignore_empty argument. |
| error |
#VALUE! |
If the value passed to the ignore_empty argument is not a logical and cannot be coerced to a logical. |
| error |
#CALC! |
If the resulting text string, including delimiters would exceed the limit for a text string in a worksheet cell of 32,767 characters. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Note: |
Number and logical values are coerced to text strings, and will appear in the format they would have under the General number format. |
| Comment: |
Where all values, including errors are to be concatenated, the ARRAYTOTEXT function may be useful, but we find the TEXTJOIN function extremely powerful in any kind of concatenation task., |
| Examples: |
Open / download sample workbook: TEXTJOIN, CONCAT, CONCATENATE.xlsx |
| |