CONCATENATE vs TEXTJOIN vs & operator — which text joiner wins?
Excel has THREE ways to join text values into one string — and each comes from a different era. CONCATENATE is the classic function nobody types anymore. TEXTJOIN is the modern powerhouse that handles delimiters and blanks. The & operator is the quick-and-dirty option every Excel user knows. Which should you actually use in 2026? All three have their place — but only one is the right choice for each situation.
⚡ The short answer
Use TEXTJOIN when joining a range with delimiters or when blanks need to be skipped — it's the modern winner for anything beyond simple pairs. Use the & operator for quick joins of 2-4 individual values ("First Last" style formulas). Skip CONCATENATE entirely — Microsoft has flagged it as legacy, and it does nothing that & or TEXTJOIN don't do better. If you need CONCATENATE-style behavior with range support but no delimiters, use CONCAT (Excel 2019+).
The three approaches at a glance
CONCATENATE
- Function, list each value
- No delimiter support
- No range support
- Can't ignore blanks
- Works in every Excel version
- Officially LEGACY as of 2019
TEXTJOIN
- Function with 3+ arguments
- First arg = delimiter
- Second arg = skip blanks (TRUE/FALSE)
- Accepts ranges natively
- Requires Excel 2019 or 365
- Modern winner for complex joins
& Operator
- Operator, not a function
- Add delimiters manually as strings
- Individual values only, no ranges
- Cleanest syntax for 2-4 values
- Works in every Excel version
- Beloved by keyboard users
The same task, three ways
Say you have first names in column A, last names in column B, and you want "Firstname Lastname" in column C for row 1:
CONCATENATE approach:
TEXTJOIN approach:
& operator approach:
All three return the same result. For this simple case, the & operator is shortest and cleanest. TEXTJOIN and CONCATENATE both add function overhead that doesn't buy you anything at this scale.
Now say you want to join a list of 20 email addresses in A1:A20, separated by semicolons, ignoring blanks. Let's see which approach still works:
TEXTJOIN — clean and simple:
CONCATENATE — nightmare:
Twenty cells manually listed with delimiter strings between each. Blanks show up as extra semicolons. Add or remove a row and rebuild the whole formula.
& operator — also nightmare:
Same problem, different syntax. This is where TEXTJOIN's range support and blank-skipping become game-changers.
Feature-by-feature scorecard
| Feature | CONCATENATE | TEXTJOIN | & Operator | Winner |
|---|---|---|---|---|
| Syntax length (2 values) | Medium | Longest | Shortest | & wins |
| Syntax length (20 values) | Terrible | Cleanest | Terrible | TEXTJOIN wins |
| Delimiter support | No | Yes, built-in | Manual, per value | TEXTJOIN wins |
| Range support (A1:A100) | No | Yes, native | No | TEXTJOIN wins |
| Ignore blank cells | No | Yes (TRUE flag) | No | TEXTJOIN wins |
| Excel 2016 & older support | Yes | No | Yes | CONCATENATE & & tie |
| Google Sheets support | Yes | Yes | Yes | All tie |
| Keyboard-friendly typing | Slow (long name) | Slow (long name) | Fast (single char) | & wins |
| Handles numbers/dates | Yes, but as text | Yes, but as text | Yes, but as text | All tie (use TEXT to format) |
| Speed on 1000+ cells | Slow | Fast | Very slow | TEXTJOIN wins |
| Editability & maintenance | Awkward | Excellent | Awkward for many values | TEXTJOIN wins |
| Officially supported | Legacy (as of 2019) | Modern | Timeless | TEXTJOIN & & win |
Score: TEXTJOIN wins 6, & operator wins 2, plus 4 ties/all-equal. CONCATENATE wins nothing. This scorecard makes the honest verdict very clear.
Why CONCATENATE is officially legacy
When Microsoft added CONCAT and TEXTJOIN in Excel 2019, they publicly marked CONCATENATE as legacy. The Microsoft Support documentation now recommends using CONCAT or TEXTJOIN instead.
The reason: CONCATENATE does exactly what CONCAT does, but without range support. And CONCAT does exactly what & does, but as a function. So CONCATENATE has become the worst of all three approaches — no delimiters, no ranges, no blank handling, no advantage anywhere.
Microsoft keeps CONCATENATE in Excel for backward compatibility with millions of existing workbooks. But no new content or training material should teach it.
Excel 2019 introduced CONCAT to replace CONCATENATE. CONCAT is nearly identical but supports ranges: =CONCAT(A1:A10) works, =CONCATENATE(A1:A10) just returns A1's value. CONCAT is still delimiter-less — for delimiters, TEXTJOIN is the right choice. Think of the family as: & for quick pairs, CONCAT for ranges without delimiters, TEXTJOIN for anything with delimiters or blank-skipping.
Where TEXTJOIN decisively wins
1. Joining ranges with delimiters
Any time you have a range of cells and need them joined with commas, semicolons, pipes, or newlines, TEXTJOIN is the only good option. This is the most common professional use case.
2. Ignoring blank cells automatically
Say your range has empty cells scattered throughout. Without blank-skipping, you get "A,,B,,C,,D" with double delimiters. TEXTJOIN's second argument (TRUE) skips them cleanly for "A,B,C,D".
The TRUE tells TEXTJOIN "ignore blanks". Change it to FALSE and blanks become empty strings between delimiters. This one flag saves hours of formula gymnastics that would otherwise be required with & or CONCATENATE.
3. Building CSV or email lists dynamically
Turning a column of items into a comma-separated string for pasting into forms, emails, or SQL queries. TEXTJOIN is the tool.
This filters to active emails only, then joins them with semicolons — a modern one-line pattern impossible with CONCATENATE or &. See the FILTER vs AutoFilter comparison for more on the FILTER function.
4. Multi-line text with CHAR(10)
To join with line breaks (for cells with wrap text enabled):
CHAR(10) is the newline character. TEXTJOIN handles this cleanly. Building the same result with & requires nesting CHAR(10) between every pair manually.
Where the & operator decisively wins
1. Quick joins of 2-4 values
Building "Firstname Lastname", "Product-SKU", or "$Amount currency" strings. The & operator is faster to type, shorter to read, and immediately clear.
vs
Both work. The first is shorter and cleaner. TEXTJOIN's overhead isn't worth it for 2 values.
2. Concatenating within longer formulas
When building a text string as part of a larger calculation — like a lookup key or dynamic reference — & blends into the surrounding formula naturally.
This constructs a compound lookup key inline. TEXTJOIN here would fragment the formula visually.
3. Prefix and suffix operations
Adding "$" before a number, ".pdf" after a filename, or wrapping text in quotes:
These are prefix/suffix operations, not "joining a list". The & operator is the natural fit.
Where CONCATENATE... doesn't win
Genuinely nothing. Every scenario where CONCATENATE works, either the & operator does it more concisely or TEXTJOIN does it more powerfully. If you're editing an existing formula that uses CONCATENATE, leave it — don't refactor for the sake of it. But don't write new CONCATENATE formulas either.
CONCATENATE's descriptive function name makes it slightly easier to explain to absolute beginners than the abstract & symbol. Some instructors still teach it as an introduction to functions. But once students understand what CONCATENATE does, immediately introduce & as the shorter modern alternative — and TEXTJOIN as the professional tool.
The decision framework
Which should you use?
- Joining 2-4 individual values with simple delimiters → & operator
- Joining a range (5+ cells or a whole column) → TEXTJOIN
- Need to skip blank cells automatically → TEXTJOIN (TRUE flag)
- Building CSV, email lists, or delimited output → TEXTJOIN
- Concatenating within a larger formula (e.g. lookup key) → & operator
- Prefix or suffix operations ("$" + number) → & operator
- Multi-line output with CHAR(10) → TEXTJOIN
- Excel 2016 or older, need to join a range → & operator (chain manually)
- Existing CONCATENATE formula that works → Leave it alone
- Writing any new text-join formula in 2026 → Never CONCATENATE
Real-world patterns worth knowing
Building full addresses from parts
If any part is blank (say, no unit number), TEXTJOIN skips it cleanly. Building this with & would either include ugly ", , " gaps or require IF statements to check each field.
Comma-separated list of unique values
Combines TEXTJOIN with UNIQUE for "APAC, EU, US" style summaries. Modern Excel makes this one line.
Concatenating numbers with formatting preserved
The TEXT function formats the number before & joins it. Without TEXT, you'd get "Total: 15420.5" instead of "Total: $15,420.50". This is one of the most common & patterns in professional dashboards.
Dynamic lookup keys
Combining two columns into a compound key for lookups. The "|" pipe separator prevents false matches (like "AB" & "C" matching "A" & "BC"). See XLOOKUP vs VLOOKUP for lookup fundamentals.
Common mistakes to avoid
1. Using CONCATENATE with a range (silent failure)
=CONCATENATE(A1:A10) returns only A1's value silently — no error, no warning. Users think they joined the range but only got one cell. TEXTJOIN or CONCAT (Excel 2019+) handle ranges correctly.
2. Forgetting to convert numbers with TEXT
Joining a number directly (like ="Price: " & A1) shows the raw number without formatting. Wrap numbers in TEXT to preserve currency, dates, or decimal places: ="Price: " & TEXT(A1, "$#,##0.00").
3. Not using blank-skipping in TEXTJOIN
Passing FALSE (or omitting the argument) as TEXTJOIN's second argument keeps blanks, producing outputs like "A, , B, , , C". Always pass TRUE unless you specifically need empty positions preserved.
4. Chaining & for 10+ cells
If you find yourself typing =A1 & ", " & A2 & ", " & A3 & ", " & ... for many cells, stop. That's TEXTJOIN territory — the & approach is unmaintainable at scale and adding rows breaks the formula.
Related resources
Master Excel text manipulation
Full coverage of text functions — SUBSTITUTE, TRIM, LEFT, RIGHT, MID, and the join family — in the function library.
Browse Text Functions → TEXTJOIN Function Page →Frequently asked questions
What is the difference between CONCATENATE and TEXTJOIN?
CONCATENATE joins multiple text values into one string with no delimiter support and no way to skip blanks — you list each value individually. TEXTJOIN joins values with a specified delimiter between each one and can ignore blank cells automatically. TEXTJOIN also accepts entire ranges (like A1:A10) as a single argument, while CONCATENATE requires each cell listed separately.
Is TEXTJOIN better than CONCATENATE?
For anyone using Excel 2019 or newer, yes — TEXTJOIN is better than CONCATENATE in almost every way. It supports delimiters, ignores blanks automatically, and accepts ranges. CONCATENATE requires you to add delimiters manually and lists each cell separately. Microsoft has even marked CONCATENATE as legacy in favor of the newer CONCAT and TEXTJOIN functions.
Should I use the & operator or CONCATENATE?
The & operator is shorter and more universally recognized than CONCATENATE for joining a few values. For simple joins like A1&B1 or first name & " " & last name, & is cleaner. CONCATENATE has no real advantage over the & operator — both do the same thing. Use TEXTJOIN when you need delimiters or want to ignore blanks, and use & for quick joins of a few cells.
Does TEXTJOIN work in older Excel versions?
No, TEXTJOIN requires Excel 2019, Excel 365, or newer. It does not work in Excel 2016 or older. The & operator and CONCATENATE have been in Excel since the earliest versions and work everywhere. For maximum backward compatibility, use the & operator; for older Excel with delimiter needs, chain & with delimiter strings manually.
How is CONCAT different from CONCATENATE?
CONCAT is the modern replacement for CONCATENATE that was introduced alongside TEXTJOIN in Excel 2019. CONCAT accepts entire ranges as arguments (like A1:A10), while CONCATENATE requires each cell listed individually. CONCAT does not support delimiters — for delimiters, use TEXTJOIN instead. Think of CONCAT as CONCATENATE with range support.
Can I join a range of cells with the & operator?
No, the & operator only joins individual values, not ranges. You would need to write A1&A2&A3&A4 to join four cells with &. For joining ranges automatically, use TEXTJOIN(",", TRUE, A1:A100) which handles the entire range in one function. This is one of TEXTJOIN's biggest advantages over both & and CONCATENATE.
Do these text functions work in Google Sheets?
Yes, all three approaches work in Google Sheets with identical syntax to Excel. CONCATENATE and the & operator have been in Google Sheets since day one. TEXTJOIN was added later but has been stable for years. All examples in this article transfer directly between Excel and Google Sheets. See Excel vs Google Sheets for more platform comparisons.
How do I join numbers or dates as text?
Wrap the value in the TEXT function to control formatting: ="Total: " & TEXT(A1, "$#,##0.00"). Without TEXT, numbers show unformatted (like "15420.5" instead of "$15,420.50") and dates show as serial numbers. TEXT gives you complete formatting control for any joined output.
What is TEXTJOIN's blank-skipping argument for?
TEXTJOIN's second argument (TRUE or FALSE) controls whether blank cells are skipped or included. Set to TRUE, blank cells produce no output — you get "A, B, C" from a range with blanks. Set to FALSE, blank cells produce empty strings between delimiters — you get "A, , , B, , C". Almost always use TRUE unless you specifically need position-preserved output.
Bottom line: TEXTJOIN for ranges and delimiters. & for quick joins and inline concatenation. Never write new CONCATENATE. The right tool depends on scale — but never on habit.