How to Join Cells in Excel: Every Method Explained

Joining cells in Excel sounds simple — and often it is. But depending on what you're actually trying to do, "joining cells" can mean two very different things: merging cells (combining the cells themselves into one physical cell) or concatenating values (combining the text or data inside cells into a single result). Understanding the difference is the first step to doing it right.

Merging vs. Concatenating: Why It Matters

These two approaches look similar on screen but behave completely differently under the hood.

Merging cells physically combines two or more adjacent cells into one larger cell. The content from only the upper-left cell is kept; everything else is discarded. Merged cells are primarily a formatting tool — useful for headers and layouts, but they can cause serious problems with sorting, filtering, and formulas.

Concatenating leaves your cells exactly where they are. Instead, it pulls the values from multiple cells and combines them as text into a new cell. This is the method you want when you need to combine first and last names, build full addresses, or assemble product codes.

Knowing which one your situation calls for will save you a lot of frustration.

How to Merge Cells in Excel

Using the Merge & Center Button

This is the most common method for merging:

1. Select the cells you want to merge (they must be adjacent)
2. Go to the Home tab on the ribbon
3. Click the Merge & Center dropdown arrow
4. Choose from the options:

⚠️ A warning: if more than one cell in your selection contains data, Excel will keep only the upper-left value and delete the rest — and it will warn you before doing so.

When Merging Makes Sense

Merging works well for visual formatting — spanning a title across multiple columns, creating clean report headers, or building a print-ready layout. It starts causing headaches the moment you try to sort a column that includes merged cells, use those cells in formulas, or copy and paste data around them.

How to Concatenate (Join Cell Values) in Excel

This is where the real power is for data work. Excel gives you several tools to do this.

Using the CONCAT Function

=CONCAT(A1, " ", B1)

CONCAT replaced the older CONCATENATE function in Excel 2016. It accepts individual cells, ranges, or text strings. You can chain together as many values as you need, inserting spaces, commas, or any characters between them.

Example — combining a first name in A1 and a last name in B1: =CONCAT(A1, " ", B1) → Jane Smith

Using the Ampersand Operator (&)

The & operator is a quick, formula-free way to join values:

=A1 & " " & B1

This does exactly the same thing as CONCAT but with less typing. Many experienced Excel users default to this method for simple joins.

Using TEXTJOIN (The Most Flexible Option) 🔧

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

TEXTJOIN is the most powerful concatenation tool in Excel. It takes three arguments:

• Delimiter — the character(s) to place between values (comma, space, dash, etc.)
• Ignore empty — TRUE skips blank cells; FALSE includes them
• Range — the cells you want to join

This is especially useful when you're joining a range of cells and don't want to reference each one individually. TEXTJOIN is available in Excel 2019, Excel 365, and Excel for the web. If you're on Excel 2016 or earlier, you'll need CONCAT or & instead.

Flash Fill as a Shortcut

If you want to join cells without writing a formula at all, Flash Fill can sometimes do the job automatically. Type your desired combined result in the first row, then press Ctrl + E — Excel will detect the pattern and fill the rest of the column. It's fast for one-off tasks but not reliable for dynamic data that changes.

Factors That Affect Which Method Works for You

The "right" approach to joining cells in Excel depends heavily on your specific situation:

Your Excel version plays a major role. TEXTJOIN isn't available before Excel 2016, and some behaviors differ between desktop Excel and the web version.

What you plan to do with the data matters enormously. If you're building a formatted report for printing, merged cells may be acceptable. If the data feeds into pivot tables, filters, or other formulas, merging will create problems — concatenation is almost always the better technical choice.

Whether the source data changes determines whether you need a dynamic formula or a static result. CONCAT and TEXTJOIN update automatically when source cells change; Flash Fill does not.

How many cells you're joining affects which formula is easiest. Joining two cells? The & operator is fast. Joining a column of 50 values into one string? TEXTJOIN is built for exactly that.

Your comfort with formulas is a practical variable. Flash Fill and Merge & Center require no formula knowledge at all. TEXTJOIN with custom delimiters requires understanding function syntax.

Common Issues When Joining Cells

• Numbers lose formatting — if you concatenate a date or number, Excel may strip its formatting. Wrap it in TEXT() first: =A1 & " " & TEXT(B1,"MM/DD/YYYY")
• Merged cells break sorting — Excel cannot sort a column that contains merged cells of different sizes
• CONCAT returns an error — usually means one of the referenced cells contains an error value; check your source data

The method that works cleanly in one workbook may create real problems in another, depending on how the data is structured, what version of Excel is in use, and what the spreadsheet needs to do next.