CONCATENATE

Beginner

Text

Joins two or more text strings into one string. Note: CONCAT and & operator are modern alternatives.

Syntax
=CONCATENATE(text1, [text2], ...)
Parameters
text1
Required
(text)

First text string to join

text2(text)

Additional text strings (optional)

Examples
Real-world examples to help you understand how to use CONCATENATE

Join first and last name

=CONCATENATE(A1, " ", B1)

Combines first name, space, and last name

Result: Full name

Create email address

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

Combines username with domain

Result: user@company.com

Build address

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

Combines street, city, and zip code

Result: Complete address

Common Use Cases
  • ✓Create full names from parts
  • ✓Build email addresses
  • ✓Format addresses
  • ✓Create product codes
  • ✓Combine data fields
Pro Tips
  • 💡Modern Excel: use & operator or CONCAT instead
  • 💡Add spaces or separators manually
  • 💡TEXTJOIN is more flexible for multiple items
  • 💡Can combine text and numbers
Common Errors
  • ⚠️Forgetting to add spaces between words
  • ⚠️Not converting numbers to text when needed
  • ⚠️Using with ranges (use CONCAT or TEXTJOIN)
Related Formulas
CONCATTEXTJOINAMPERSANDLEFTRIGHT

Need a Custom CONCATENATE Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula