CONCATENATE Function in Excel — Complete Guide (2026) | Sheets & Cells
TEXT FUNCTION (LEGACY)

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.

=CONCATENATE(text1, [text2], ...)

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.

CategoryText (legacy)
IntroducedExcel 2007
StatusDeprecated (still works)
Microsoft's official guidance: Use 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.

When CONCATENATE still makes sense: Only when you're maintaining an older workbook that already uses it and you don't want to introduce a new pattern. For new work, always prefer 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:

=CONCATENATE(A2, " ", 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:

=CONCATENATE(A2, "@", 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:

=CONCATENATE(A2, " has placed ", B2, " orders this quarter.")

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:

=A2 & " " & B2 & " (" & C2 & ")"

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

#NAME?

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.

Dates and currency come out ugly

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.

Result truncated or #VALUE!

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.

Ranges not working

CONCATENATE only accepts single values, not ranges. =CONCATENATE(A2:A10) returns just A2. For range concatenation, use CONCAT or TEXTJOIN.

CONCATENATE vs modern alternatives

OptionBest forTrade-off
CONCATENATEOld workbooks; backward compatibilityNo range support; deprecated by Microsoft
CONCATRange concatenation without delimiterExcel 2019+; no way to skip blanks
TEXTJOINDelimited lists from ranges, skip blanksExcel 2019+; overkill for 2-3 values
& operatorCombining a few cells inlineVerbose for many values; no range support

Version compatibility

Excel 365✓ Full (legacy)
Excel 2024✓ Full (legacy)
Excel 2021✓ Full
Excel 2019✓ Full
Excel 2016✓ Full
Excel Online✓ Full
Excel Mac✓ Full
Google Sheets✓ Full

Download the practice workbook
Every example above, plus side-by-side comparisons showing CONCATENATE, CONCAT, TEXTJOIN, and & for the same task.

📥 concatenate-practice.xlsx (coming soon)

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.

Learn about the Add-in →