CONCATENATE

Using the Excel CONCATENATE Function

Summary

The 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], ...)

Syntax Breakdown

Text1
Required. The first text value, number, or cell reference to be joined.

Text2
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 Notes

CONCATENATE 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:

  1. Enter a space after the text argument "A". Your entry would be =CONCATENATE("A ", "B");
  2. 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.

Other Options
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).