CONCATENATE Function in Excel
CONCATENATE joins two or more text strings into one. It's Excel's oldest text-joining function — and Microsoft has officially deprecated it in favor of CONCAT and TEXTJOIN. Here's how it works, and honestly, when you should use something else instead.
What it does: Combines all provided text values into a single string, in the order given. No delimiter between them — you have to include separators as literal text arguments if needed.
CONCAT or TEXTJOIN instead of CONCATENATE for new formulas. CONCATENATE is preserved for backward compatibility and continues to work in every current Excel version — but Microsoft has stopped adding features to it, and future versions may eventually remove it. If you're writing a formula today, prefer the modern alternatives.
What CONCATENATE does
CONCATENATE takes anywhere from 1 to 255 text arguments and glues them together. Numbers are converted to their default text representation. Dates come out as serial numbers (2026-03-15 becomes something like "45732") unless wrapped in TEXT. Blanks pass through as empty strings.
The classic limitation: CONCATENATE doesn't accept ranges. =CONCATENATE(A2:A10) in older Excel returns only the value of A2. This is the main reason CONCAT (which does accept ranges) was introduced in 2019 to replace it.
TEXTJOIN (with delimiter and blank-skipping), CONCAT (for ranges without delimiter), or the & operator (for a few cells inline).
Syntax breakdown
text1 Required
The first text value or cell reference. Can be a string in quotes ("Hello"), a cell reference (A2), or an expression that evaluates to text or a number.
text2, ... Optional
Additional values to concatenate. Up to 255 arguments total. Each argument is a single value or reference — not a range. To include separators between values, add them as literal text arguments: ", " or " ".
5 real-world examples
Example 1: Combine first and last name
First name in A2, last name in B2:
Result: Alice Chen. The literal " " as a separate argument provides the space. Same result as =A2 & " " & B2.
Example 2: Build an email address
Username in A2, domain in B2:
Result: alice@example.com. Simple string assembly with a literal separator.
Example 3: Build a formatted sentence
Name in A2, order count in B2:
Result: Alice Chen has placed 5 orders this quarter. Mix cell values and literal text as needed.
Example 4: Concatenate with a formatted date
Wrap the date in TEXT so it doesn't come out as a serial number:
=CONCATENATE("Order shipped on ", TEXT(A2, "mmm d, yyyy"))Result: Order shipped on Mar 15, 2026. Without TEXT, the date would appear as "45732" — the raw serial number.
Example 5: When you should use & or TEXTJOIN instead
Same result with & — shorter and idiomatic:
Or with TEXTJOIN for a range:
=TEXTJOIN(", ", TRUE, A2:A10)Takeaway: If you're writing new formulas, these alternatives are almost always clearer than CONCATENATE.
Common errors and how to fix them
Almost impossible with CONCATENATE — it exists in every modern Excel. If seen, check spelling: it's C-O-N-C-A-T-E-N-A-T-E (twelve letters). One of the most commonly misspelled function names.
CONCATENATE uses raw values, ignoring cell formatting. Dates become serial numbers, currencies lose $ signs. Fix: wrap each value in TEXT() with the desired format string.
Excel's cell content limit is 32,767 characters. Concatenating many long strings can hit this limit. Fix: split into multiple cells, or use PowerQuery for very large text assembly.
CONCATENATE only accepts single values, not ranges. =CONCATENATE(A2:A10) returns just A2. For range concatenation, use CONCAT or TEXTJOIN.
CONCATENATE vs modern alternatives
| Option | Best for | Trade-off |
|---|---|---|
| CONCATENATE | Old workbooks; backward compatibility | No range support; deprecated by Microsoft |
| CONCAT | Range concatenation without delimiter | Excel 2019+; no way to skip blanks |
| TEXTJOIN | Delimited lists from ranges, skip blanks | Excel 2019+; overkill for 2-3 values |
| & operator | Combining a few cells inline | Verbose for many values; no range support |
Version compatibility
Download the practice workbook
Every example above, plus side-by-side comparisons showing CONCATENATE, CONCAT, TEXTJOIN, and & for the same task.
Related functions
Frequently asked questions
Should I use CONCATENATE or CONCAT?
For new formulas, use CONCAT — it accepts ranges (e.g., =CONCAT(A2:A10)) which CONCATENATE cannot. For delimited output that skips blanks, use TEXTJOIN. Only stick with CONCATENATE when maintaining an existing workbook where consistency matters more than modernization.
Is the & operator the same as CONCATENATE?
Functionally yes, for two-value cases. =A2 & " " & B2 gives the same result as =CONCATENATE(A2, " ", B2). The & operator is shorter for quick inline concatenation. Neither handles ranges — for those, use CONCAT or TEXTJOIN.
Why does my date appear as a number after CONCATENATE?
Because Excel stores dates as serial numbers internally (2026-03-15 is stored as 45732), and CONCATENATE uses the raw stored value. Wrap dates in TEXT: =CONCATENATE(A2, ": ", TEXT(B2, "yyyy-mm-dd")).
Will Microsoft remove CONCATENATE?
Not in the near future. It's marked as "for backward compatibility" but remains available in every Excel version through 2025. The safe assumption is that CONCATENATE will keep working indefinitely — Microsoft is very conservative about removing formula functions. But no new features will be added.
Can CONCATENATE handle a range like A2:A10?
Not correctly. It returns only the value of the first cell in the range. For range concatenation, use CONCAT (available in Excel 2019+) or TEXTJOIN. This is CONCATENATE's biggest limitation and the main reason it was superseded.
How many arguments can CONCATENATE take?
Up to 255 individual arguments. Each argument must be a single value or reference, not a range. Total output must fit within Excel's 32,767 character cell limit.
Are there performance differences between CONCATENATE, CONCAT, TEXTJOIN, and &?
Negligible for small numbers of cells. For thousands of concatenations, TEXTJOIN with ranges is fastest — it processes the whole range in one call. Chained & operators and CONCATENATE with 100+ arguments are slowest. In practice, formula clarity matters more than performance for text joining.
Modernize your text formulas — with the Sheets & Cells AI Add-in
Highlight any CONCATENATE formula in your workbook and the Add-in suggests a modern rewrite using CONCAT, TEXTJOIN, or & — with an explanation of why. All inside Excel.