The Excel Concat function and the Textjoin function both join together text strings.
The Excel CONCAT function joins together a series of supplied text strings into one combined text string.
The syntax of the function is:
where the text arguments are one or more text strings (or arrays of text strings), that you want to join together.
Column D of the following spreadsheet shows two simple examples of the Concat function.
The following Concat function can be used to concatenate the text strings in cells A2, B2 and C2 of the above example spreadsheet:
This formula returns the text string "C:\Users\Jim\Documents\notes.doc".
If you want to concatenate 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 Concat function, the underlying number will appear in the resulting text string, rather than the actual date or time.
Therefore, if you want to concatenate 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:
In order to concatenate the contents of cells A2, B2 and C2 of the above spreadsheet, with the date formatted correctly, we should use the Concat function as follows:
This formula returns the text string "Jim Smith, DOB: 01/02/1990".
Note that, in the example above:
See the Microsoft Office website for further examples of the Excel Concat function.
If you get an error from the Excel Concat function, this is likely to be one of the following:
|#VALUE!||-||Occurs if the result of the Concat function exceeds 32,767 characters.|
|#NAME?||-||Occurs if you are using an older version of Excel (pre-2019), that does not support the Concat function.|