The Excel Textjoin function joins together a series of supplied text strings into one combined text string. The user can specify a delimiter to add between the individual text items, if required.
The syntax of the Textjoin function is:
where the arguments are as follows:
|[delimiter]||-||If omitted, no delimiter is used.|
|[ignore_empty]||-||If omitted, the function uses the default value TRUE (ignore empty cells).|
|text1, [text2], ...||-||One or more text strings (or arrays of text strings), that you want to join together.|
If you want to join text with dates in Excel, you need to beware that dates and times are actually stored as simple numbers in Excel, and if you enter a date or a time directly into the Textjoin function, the underlying number will appear in the resulting text string, not the formatted date or time.
Therefore, if you want to join a text string with a date or a time, you need to use the Excel Text function to convert the date or time value into a text string first. This is shown in the example below:
Note that, in the example above:
See the Microsoft Office website for further examples of the Excel Textjoin function.
If you get an error from the Excel Textjoin function, this is likely to be one of the following:
|#VALUE!||-||Occurs if the result of the Textjoin function exceeds 32,767 characters.|
|#NAME?||-||Occurs if you are using an older version of Excel (pre-2019), that does not support the Textjoin function.|