Excel Merge Multiple Cells Into One Cell: A Clear Guide

How-to basics · Updated November 19, 2026

To merge cells in Excel, select the range, then choose Home > Merge & Center ▼ > Merge Cells. This makes one larger cell, but keeps only the value in the range’s upper-left cell; if you need to combine all the contents, use a formula such as TEXTJOIN instead.

What merging cells actually does

Merging changes the worksheet’s layout: several adjacent cells become one larger cell. Excel treats the resulting area as a single cell, located at the top-left position of the original selection. The merged cell can hold one value or formula, just like any other cell.

A merge does not join the contents of the selected cells. If A1 contains “North” and B1 contains “Region,” merging A1:B1 does not produce “North Region.” Excel retains “North” and removes “Region” from the merged area. This difference is the most important point to understand before using the feature.

Merging is useful when a heading should sit across several columns, such as a report title above a table. It is usually a poor choice for the body of a data table, where each row and column should remain a separate, consistently structured field.

How to merge cells in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, use the Home tab’s Alignment group. Select a rectangular range of adjacent cells, then open the arrow beside Merge & Center and choose the option that matches your goal:

  • Merge & Center combines the cells and centers the remaining value horizontally.
  • Merge Across merges cells separately across each row of the selected range. It does not create one large cell spanning all rows and columns.
  • Merge Cells combines the selection without automatically centering its contents.
  • Unmerge Cells separates a previously merged cell back into individual cells.

For example, selecting A1:D1 and choosing Merge Cells creates one cell spanning those four columns. Selecting A1:D3 and choosing Merge Across creates three separate merged cells: one across each row. If you choose Merge & Center on that whole 3-by-4 range, Excel creates one merged area spanning all twelve cells.

Excel may display a warning that only the upper-left value will be kept. Check the selection before confirming. In Excel for Mac, the equivalent controls are on the Home tab; the precise ribbon layout can vary with the window size. Excel for the web also provides merge controls on Home, though available options and ribbon presentation may differ slightly from the desktop app.

How to combine the contents instead

If the goal is to put text from multiple cells into one cell, concatenate the values rather than merging the source cells. A formula creates a combined result in a separate cell, while leaving the original values available to edit, sort, or reuse.

With a first name in A2 and a last name in B2, enter this formula in C2:

=A2&" "&B2

If A2 contains “Maya” and B2 contains “Chen,” the result is “Maya Chen.” The ampersand joins the pieces, and the quoted space supplies a separator. Change the text between the quotes to a comma, hyphen, or other divider as needed.

For a range of cells, TEXTJOIN can add a delimiter and optionally skip empty cells. With department labels in A2:A4, enter this in B2:

=TEXTJOIN(" / ",TRUE,A2:A4)

If the cells contain “Sales,” a blank, and “Support,” the result is “Sales / Support.” The first argument sets the separator, TRUE tells Excel to ignore empty cells, and the range is the text to combine. TEXTJOIN is available in Microsoft 365 and newer Excel versions; older versions may require a chain of ampersands or another approach.

These formulas update when their source cells change. If you need a fixed text result, copy the formula cell and use Home > Paste > Paste Values. That replaces the formula with its current result, while the original source cells remain unchanged.

Choose the right method for the job

Use merging for presentation, and use a formula for combining data. The distinction matters because merged cells can interfere with common spreadsheet tasks, whereas a formula result remains in a normal cell that can be filtered, sorted, and referenced.

  • Use Merge & Center for a short title above a report or for a label that visually spans columns.
  • Use TEXTJOIN or & when the words or values from two or more cells need to appear together as one text result.
  • Use Center Across Selection when you want a heading centered across columns without merging them. Open Format Cells with Ctrl+1 on Windows, select the Alignment tab, then choose Center Across Selection from Horizontal. On Mac, use Command+1 to open Format Cells.
  • Keep cells separate when the range is part of a sortable, filterable, or formula-driven dataset.

Center Across Selection changes alignment rather than the cell structure. This often gives a similar appearance to Merge & Center while avoiding a merged cell. It is especially useful for headings over columns that will later be sorted or used in calculations.

What happens to data, formatting, and formulas

When merging a range that contains more than one populated cell, Excel keeps the upper-left cell’s content and discards the other cell contents from the merged area. Do not rely on unmerge to restore discarded values: unmerging restores the cell layout, not the removed data. If you have not yet confirmed the merge, cancel the warning; if you have just completed it, Ctrl+Z on Windows or Command+Z on Mac can undo it.

Formatting and alignment can also affect what you see. The merged cell generally uses the formatting of the upper-left cell, and Merge & Center centers its content horizontally. You can change alignment afterward from Home > Alignment. If the text does not fit vertically, use Wrap Text or adjust the row height. A merge does not automatically make the row tall enough for every long heading.

Formulas that refer to a merged range can be confusing because the merged area has only one usable cell address: its upper-left address. For instance, a range merged from A1:C1 is addressed as A1 in formulas. If another cell in the original range had a formula, its result is not preserved when the merge removes that cell’s contents.

Common problems and limitations

Merged cells can complicate everyday worksheet operations. Excel expects a consistent grid for many tasks, and a cell spanning several rows or columns breaks that pattern. You may find that sorting or filtering a range containing merged cells behaves unexpectedly or is blocked. Merging is also unavailable for cells inside an Excel table, because tables depend on a regular cell-by-cell structure.

Copying and pasting can be awkward when the source and destination ranges have different merged layouts. A paste may fail or produce a message about merged cells. Before copying a block, check whether the source and destination have matching dimensions and merge patterns. When they do not, unmerging first or pasting values into a clean range can be simpler.

If Merge & Center is disabled, check whether the selected cells are part of a table, whether the worksheet is protected, and whether the selection is suitable for merging. Also check that the workbook is not in a state that restricts editing. Unprotecting a sheet may require the password set by its owner; do not assume a protected sheet can be changed without permission.

Unmerge cells and prevent data loss

To separate a merged cell, select it and choose Home > Merge & Center ▼ > Unmerge Cells. The original grid returns, but the content remains only in the upper-left cell. Cells that were cleared during the original merge stay blank; unmerging does not reconstruct their former contents.

Before merging a range with multiple entries, preserve the values in another location or combine them with a formula first. A safe workflow is to create a TEXTJOIN result in an unused cell, verify the output, and then decide whether the visual merge is still needed. If you are editing a shared or important workbook, save a copy before making structural changes.

Frequently Asked Questions

Can I merge cells in Excel without losing data?
Not by using the merge command alone when several selected cells contain values. Excel retains only the upper-left value. Combine the contents first with TEXTJOIN or an ampersand formula, or move the other values elsewhere before merging.

How do I merge cells without centering the text?
Open the arrow beside Home > Merge & Center and choose Merge Cells. This merges the selected cells without applying the automatic horizontal centering of Merge & Center. You can set alignment separately afterward.

How do I combine cells with a space or comma between them?
Use an ampersand formula with the separator in quotation marks, or TEXTJOIN for a range. For example, a space can be written as ” “, while a comma followed by a space is “, “. TEXTJOIN can also skip blank cells when its ignore-empty argument is TRUE.

Can I sort a range that contains merged cells?
Merged cells often prevent normal sorting or cause layout problems because the rows no longer have a uniform structure. For sortable data, unmerge the range and keep one value per cell. Use Center Across Selection for a heading that only needs to look centered across columns.

Does unmerging restore the values that were removed?
No. Unmerge Cells restores the separate cell layout, but it does not bring back content discarded during the merge. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, or restore the values from a saved copy or another source.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.