How to Join Cells in Excel: Methods, Use Cases, and What to Consider

Joining cells in Excel sounds simple — and for basic tasks, it is. But the moment you dig into real-world spreadsheets, you quickly discover there are multiple ways to do it, each behaving differently depending on your data, your Excel version, and what you actually need the result to do.

Here's a clear breakdown of how cell joining works in Excel, what the options actually mean, and why the right choice isn't always obvious.

What Does "Joining Cells" Actually Mean?

In Excel, "joining cells" refers to two distinct operations that are often confused:

1. Merging cells — physically combining multiple cells into one larger cell in the spreadsheet layout
2. Concatenating cell values — combining the text or data from multiple cells into a single result, usually in a formula

These are fundamentally different. Merging is a formatting action. Concatenating is a data action. Understanding which one you need is the first real decision.

Method 1: Merging Cells (The Visual Approach)

Merge & Center is the most visible option. You'll find it under the Home tab in the Alignment group.

To merge cells:

1. Select the range of cells you want to combine
2. Click Merge & Center (or the dropdown arrow next to it for more options)
3. Excel collapses those cells into one

The dropdown gives you three variants:

⚠️ Important caveat: when you merge cells, Excel keeps only the upper-left cell's value and discards everything else. If your selected range contains data in multiple cells, most of it disappears. Excel will warn you, but it won't recover the lost values automatically.

Merged cells also create real problems for sorting, filtering, and formulas — which is why many Excel power users avoid them for data-heavy sheets and reserve them purely for headers or visual layout purposes.

Method 2: Concatenation with Formulas (The Data Approach)

If you want to combine the content of multiple cells — first name and last name, city and state, a product code and a description — you want concatenation, not merging.

Using the & Operator

The simplest approach is using the ampersand:

To add a space between values:

This works in every modern version of Excel and is easy to read.

Using the CONCATENATE Function

CONCATENATE does the same job as & but in function form. It's still supported but considered legacy — Microsoft now recommends its replacement.

Using CONCAT (Excel 2019 and later)

CONCAT accepts ranges directly, which CONCATENATE doesn't. This makes it significantly faster when joining across many columns.

Using TEXTJOIN (Excel 2019 and later) 🔧

TEXTJOIN is the most powerful option for combining multiple cells. It lets you:

• Define a delimiter (comma, space, dash — anything)
• Choose whether to ignore empty cells (the TRUE argument above)
• Accept ranges instead of individual cell references

This is the function that handles messy, inconsistent data most gracefully.

How Excel Version Affects Your Options

Not all functions are available in all versions:

If you're sharing files with colleagues using older versions of Excel — or if you're working in Excel for the web — function availability can vary. A formula using TEXTJOIN will display an error in Excel 2016 or earlier.

When Merging Breaks Things (And What to Use Instead)

Merged cells are notorious for causing issues:

• Sorting fails if any merged cells exist within the sort range
• AutoFill behaves unpredictably across merged rows or columns
• Pivot tables won't recognize merged cell structures correctly
• VLOOKUP and INDEX/MATCH can return unexpected results when referencing merged ranges

A common workaround professionals use is Center Across Selection — a formatting option that looks like a merged cell visually but doesn't actually merge the cells. You'll find it under Format Cells → Alignment → Horizontal → Center Across Selection. It solves the layout problem without the functional downsides.

Variables That Shape the Right Approach

The best method depends on factors specific to your spreadsheet:

• Is this a data table or a display layout? Data tables rarely benefit from merging. Headers and dashboards sometimes do.
• Will others use this file? Merged cells in shared workbooks can cause conflict errors and unexpected behavior.
• Do you need the joined result to be dynamic? Formulas update automatically when source data changes; merged cells don't.
• Are you working with large ranges? TEXTJOIN scales better than chaining & operators across dozens of columns.
• What Excel version are you and your collaborators using? This directly limits which functions are safe to use.

The gap between "how to join cells" and "which method is right for this spreadsheet" comes down to how your data is structured, how the file will be used, and who else might open it. Those details live in your setup — not in a general guide.