Using the Excel CONCATENATE Function
SummaryThe CONCATENATE function joins one or more text strings. If you are using Excel 2016 or later, Excel Mobile, or Excel Online, CONCATENATE has been replaced with CONCAT.
Syntax=CONCATENATE (text1, [text2], ...)
Required. The first text value, number, or cell reference to be joined.
Optional. Additional text values, numbers, or cell references to be joined. The function supports up to 255 items and up to 8,192 characters.
Usage NotesCONCATENATE joins one or more strings consisting of text, values, and cell references. The function was been replaced by CONCAT in Excel 2016 and later versions, though it still works to support backwards compatibility.
Problems With CONCATENATE
Text items must be enclosed in quotation marks (" "). However, separate text items should be separated with a comma. For example, =CONCATENATE("Excel""Training.com") would return Excel"Training.com with an extra quotation mark. Rather, enter =CONCATENATE("Excel ", "Training.com").
You will need to add spaces where desired when using CONCATENATE. For example, =CONCATENATE("A","B") will return AB. To enter a space between "A" and "B" you have two options:
- Enter a space after the text argument "A". Your entry would be =CONCATENATE("A ", "B");
- Enter a blank space in quotes. The formula would be as such =CONCATENATE("A"," ","B")
If you receive the #NAME? error you may have forgotten a quotation mark in your text argument.
Instead of CONCATENATE you can use the CONCAT function. You can also use the ampersand (&) to join text items. For example, =A1 & B1 would produce the same result as =CONCATENATE(A1,B1).