Syntax
CONCATENATE(text1, [text2, ...])
| Parameter | Description |
|---|---|
| text1 | Parameter of the CONCATENATE function. |
| [text2 | (Optional.) Parameter of the CONCATENATE function. |
| ...] | Parameter of the CONCATENATE function. |
Examples
| A | B | C | |
|---|---|---|---|
| 1 | First | Last | Full Name |
| 2 | John | Smith | John Smith |
| 3 | Jane | Doe | Jane Doe |
| 4 | Bob | Wilson | Bob Wilson |
Combine first and last name
Formula
=CONCATENATE(A2, " ", B2)
Returns: "John Smith" — joins first name, a space, and last name
Build a full address
Formula
=CONCATENATE(A2, ", ", B2, ", ", C2, " ", D2)
Returns: "123 Main St, Springfield, IL 62704"
Create an email from name parts
Common Errors
#VALUE!
One of the arguments is an unsupported type. Numbers and dates are automatically converted, but errors in referenced cells will propagate.
#NAME?
You may have misspelled CONCATENATE. Consider using the shorter & operator instead: =A2 & " " & B2.
Tips
Use & instead
The ampersand is shorter and easier to read: =A2 & " " & B2 does the same thing as CONCATENATE.
Include numbers
To format numbers in concatenated text, wrap them with TEXT: =A1 & " earned " & TEXT(B1, "$#,##0").
TEXTJOIN for lists
To join many cells with a delimiter, use TEXTJOIN(", ", TRUE, A1:A10) instead of long CONCATENATE chains.
Try CONCATENATE in Viztab
Import your data and use CONCATENATE with 370+ other formulas. No signup required.
Open Viztab