How to Use CONCATENATE in Excel (Combine Text + Free Generator)

How to Use CONCATENATE in Excel — Step by Step

The CONCATENATE function combines text from multiple cells into one. It is indispensable for formatting full names, building addresses, generating email addresses, and any scenario where you need to merge column values into a readable string.

Step-by-Step Walkthrough: Combine First & Last Names

Suppose you have first names in column A and last names in column B. You want full names in column C.

Practical CONCATENATE Examples

Combine first and last name with space:

=CONCATENATE(A1, " ", B1)

Build a full address:

=CONCATENATE(A1, ", ", B1, ", ", C1, " ", D1)

Format a number with text:

=CONCATENATE("Total: $", TEXT(A1, "#,##0.00"))

Generate an email address:

=CONCATENATE(LOWER(A1), ".", LOWER(B1), "@company.com")

Adding Separators and Spaces

To add spaces, commas, or any text between values, include them as separate arguments wrapped in quotes:

• Space: =CONCATENATE(A1, " ", B1) → "John Smith"
• Comma + space: =CONCATENATE(B1, ", ", A1) → "Smith, John"
• Dash: =CONCATENATE(A1, " - ", B1) → "Sales - Report"
• Line break: =CONCATENATE(A1, CHAR(10), B1) (turn on Wrap Text)

Handling Dates and Numbers

CONCATENATE converts everything to text. Raw dates become serial numbers (e.g. 45678) and numbers lose formatting. Use TEXT() to control the output:

=CONCATENATE("Order date: ", TEXT(A1, "mm/dd/yyyy"))

=CONCATENATE("Amount: $", TEXT(B1, "#,##0.00"))

CONCATENATE vs TEXTJOIN vs Ampersand (&)