Quick Answer
CONCAT Function
CONCAT combines multiple text strings into a single string.
✓ Excel✓ Google SheetsExcel Excel 2019 and later
Syntax
CONCAT
(text1, [text2], ...)
Parameters
| Parameter | Description | Required |
|---|---|---|
| text1 | The first text string to concatenate. | Required |
| text2 | Optional additional text strings to concatenate. | Optional |
Basic Example
Combine first and last name
=CONCAT("John ", "Smith")ResultJohn Smith
Combines "John " and "Smith" into "John Smith".
Advanced Examples
Example 1: Create email from name
Email generationCombine first and last name to create an email address
=CONCAT(LOWER(A1), ".", LOWER(B1), "@company.com")Result: [email protected]
Creates a standardized email from first and last name.
Example 2: Concatenate with array
Dynamic arraysCombine values from a range into one string
=CONCAT(A1:A5)Result: ABCDE
In Excel 365, CONCAT automatically handles arrays.
How CONCAT Works
CONCAT joins text strings in the order they are provided, without any separator. For adding separators, use TEXTJOIN instead.
1
Select output cell
Choose where the result should appear.
2
Enter formula
Type =CONCAT(text1, text2, ...).
3
Press Enter
The result shows the combined text.
Important Notes & Limitations
CONCAT has no built-in separator.
For older Excel versions, use CONCATENATE or the & operator.
Common Errors & Fixes
#NAME?Function not supported in Excel versionFix: Use CONCATENATE or & operator instead.
Download Practice File
CONCAT
concatPractice CONCAT with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the CONCAT function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Related Tutorials
Frequently Asked Questions
What is the difference between CONCAT and CONCATENATE?
CONCAT is newer and supports ranges, while CONCATENATE only supports individual arguments.
Can I use CONCAT with numbers?
Yes, numbers are automatically converted to text.