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

Joining cells in Excel sounds straightforward — and often it is. But "joining" actually means two different things depending on what you're trying to do: merging cells (combining the cells themselves into one larger cell) or concatenating values (combining the text or data inside cells into a single string). Mixing these up leads to lost data, broken formulas, and a lot of frustration.

Here's how both approaches work, when each one makes sense, and what variables will shape which method actually fits your situation.

The Two Meanings of "Joining" Cells

Merging Cells (Visual Layout)

Merge & Center is the button most people reach for first. Found in the Home tab under the Alignment group, it physically combines two or more adjacent cells into one. The result looks clean — a single wide cell spanning multiple columns or rows, often used for headers.

What most users don't realize: only the upper-left cell's value is kept. Everything in the other cells is silently deleted. Excel will warn you, but it's easy to click past that warning without registering what it means.

Merge types available in Excel:

Merged cells come with real limitations: you can't sort columns that contain merged cells, filtering behaves unpredictably, and many formulas (especially array formulas) break or refuse to work. For pure visual formatting — like a report title spanning the page — merging works fine. For anything involving data manipulation, it's usually the wrong tool.

Concatenating Cell Values (Data Joining)

If your goal is to combine the content of cells — first name + last name, city + state, SKU code + description — you want concatenation, not merging. The cells themselves stay separate; you create a new cell that displays the combined result.

Excel gives you several ways to do this:

Methods for Combining Cell Values

The Ampersand (&) Operator

The simplest method. To join the values in A1 and B1:

=A1&B1 

To add a space between them:

=A1&" "&B1 

This works in every version of Excel and is easy to read at a glance. The downside: if you're joining many cells, the formula gets long and messy fast.

CONCATENATE Function

=CONCATENATE(A1, " ", B1) 

Functionally identical to the ampersand method. CONCATENATE is still available in modern Excel but has been officially superseded. Microsoft now recommends using CONCAT or TEXTJOIN instead.

CONCAT Function (Excel 2019 and later / Microsoft 365)

=CONCAT(A1:C1) 

CONCAT accepts ranges, so instead of listing every cell individually, you can reference an entire row or column. No separator is added automatically — the values are just pushed together.

TEXTJOIN Function (Excel 2019 and later / Microsoft 365) 🔧

=TEXTJOIN(", ", TRUE, A1:C1) 

This is the most flexible option for most use cases. The first argument is the delimiter (whatever you want between values — a comma, a space, a dash). The second argument (TRUE or FALSE) tells Excel whether to ignore empty cells. The third argument is your range.

For combining lists, addresses, or any structured data with consistent separators, TEXTJOIN is usually the cleanest solution.

Variables That Change Which Method Works Best

Not every approach works the same way across all setups:

Excel version matters significantly. TEXTJOIN and CONCAT aren't available in Excel 2016 or earlier. If you're sharing files with colleagues on older versions, formulas using these functions will return errors on their machines. The ampersand method and CONCATENATE work across essentially all Excel versions.

Google Sheets compatibility — if your file crosses between Excel and Google Sheets, TEXTJOIN works in both. Ampersand concatenation also transfers cleanly. Merged cells, however, can cause layout issues when switching platforms.

Data size and structure — concatenating hundreds of rows is no problem; Excel handles this efficiently. But if your data changes frequently, you'll need to decide whether to keep the formula live (so it updates automatically) or paste the results as values only (which freezes the output but removes the dependency on source cells).

Use in tables and pivot data — merged cells will break Excel's structured Table feature (the one you enable via Insert > Table). If you're working with a proper Excel Table for filtering, sorting, or pivot tables, avoid merging entirely. Concatenation formulas work fine inside tables.

Text vs. numbers — concatenating numeric cells treats the numbers as text in the result. If you need to display a number with specific formatting (like currency or dates), use the TEXT function inside your formula:

=A1&" - "&TEXT(B1,"MM/DD/YYYY") 

Without this, dates and numbers often appear as their underlying serial numbers rather than their formatted display values.

When Merging vs. Concatenating Is the Right Call

The Part That Depends on Your Situation 🤔

The method that works best comes down to what your spreadsheet is actually for. A static monthly report used purely for printing has completely different requirements than a live data file that feeds into formulas, pivot tables, or other worksheets.

Your Excel version, whether your file is shared across different platforms or software versions, and whether the joined cells need to stay dynamic or can be fixed as static text — all of these shift the answer in meaningful ways. The techniques above cover the full range of what Excel offers, but which one slots cleanly into your workflow is something only your specific setup can answer.