Excel Merge Cells Without Losing Data: Safe Methods

Excel’s Merge & Center command does not combine the contents of two cells: it keeps the upper-left cell’s value and discards the other value. To preserve both, join the contents in a separate cell first, copy the result back as a value, and only then merge the cells—or use a non-destructive layout option instead.

What happens when you merge cells in Excel?

In Excel for Microsoft 365 on Windows, merging a range makes it one larger cell for display and editing. It does not concatenate the cells’ contents. If you select A2:B2 and choose Home > Merge & Center, Excel retains the content of A2 and removes the content of B2 from the worksheet. If A2 is blank, the merged cell will be blank even if B2 contained text.

Excel usually warns that merging cells keeps only the upper-left value. Treat that warning literally: the other contents are not merely hidden inside the merged cell. A later Unmerge Cells command restores the separate cell layout, but it does not bring back the discarded value. Undo may reverse a recent merge, but it is not a reliable recovery plan after more edits or after closing the file.

For example, if A2 contains “Ada” and B2 contains “Lovelace,” merging A2:B2 will leave “Ada,” not “Ada Lovelace.” The safe approach is to combine those words in a third cell, confirm the result, and put that result in the upper-left cell before merging.

Safest method: combine the contents before merging

Keep the original entries intact until you have checked the combined result. In this example, use C2 as a temporary formula cell, outside the range you plan to merge.

Enter the following formula in C2, assuming A2 contains Ada and B2 contains Lovelace: =A2&" "&B2. It returns Ada Lovelace.
Check that the result includes every item you need, with the intended spaces or punctuation.
Copy C2. Select A2, then use Home > Paste > Paste Values. This replaces A2 with the combined text rather than leaving a formula that depends on B2.
Select A2:B2 and choose Home > Merge & Center, or open its dropdown and choose Merge Cells if you do not want centered text.
Once you have verified the merged result and no longer need the source entries, remove the temporary formula in C2 if appropriate.

The order matters. If you put a formula such as =A2&" "&B2 in A2 and then merge A2:B2, merging removes B2. The formula can then lose its reference to the second entry. Calculating the result outside the merge range and pasting it as a value avoids that problem.

Join text with a separator, or combine several cells

The ampersand operator is a simple option when joining two cells. The formula adds a space between the values, but you can replace that space with a comma, dash, or other separator. With a street name in A2 and a unit number in B2, for instance, a comma and space might be more suitable than a plain space. The formula joins the cell contents; it does not merge the cells’ formatting or make them one cell.

For a longer row, TEXTJOIN can add one separator between nonempty entries and skip blanks. Assuming A2 contains “North,” B2 is blank, and C2 contains “Office,” enter this formula in D2: =TEXTJOIN(", ",TRUE,A2:C2). The result is North, Office, with no extra comma for the empty cell. TEXTJOIN is available in Excel 2019 and later, including Microsoft 365. In versions without it, join the needed cells with ampersands or combine them in stages.

Joining does not always preserve the way a value looks on the sheet. A date is stored as a number, so joining a date cell directly may show its serial value rather than a familiar date. If A2 contains the date 3/15/2026 and B2 contains “Review,” enter this in C2 to format the date as month/day/year in the combined text: =TEXT(A2,"m/d/yyyy")&" - "&B2. The result is 3/15/2026 - Review. Choose a date format that matches the workbook’s requirements; the formula creates text, not a date value.

Similarly, numbers may need an explicit format when turned into text. A displayed currency amount, leading zero, or percentage can look different in a joined result unless you format it with TEXT. Check the combined output before replacing the original cell, especially when the workbook uses custom number formats.

Paste the combined result as a value

A formula is useful while constructing a combined label, but leaving it in the cell you merge can create fragile references. Pasting as a value stores the displayed result as text in the destination cell. In Excel for Microsoft 365 on Windows, copy the formula cell, select the destination, then use Home > Paste > Paste Values. The Paste Values option is also available from the paste menu after right-clicking the destination.

There is no need to delete the source cells before you have checked the pasted result. Compare it with the originals, including punctuation, spaces, dates, and any leading zeros. If the result is wrong, correct the formula while the source entries are still available. For important workbooks, save a copy before making a large batch of changes; it is easier to recover from a copy than to reconstruct discarded entries.

When the source cells are on different rows or columns, decide how the information should read before joining it. A label and a description might need a colon and a space; a first and last name usually need one space. Avoid combining unrelated information merely to make a heading look wider. If readers need to sort, filter, or calculate using the separate values, keep them in separate cells.

Merge cells only after checking the range

After the combined value is safely in the upper-left cell, select the cells to merge. Use Home > Merge & Center for a centered heading. The dropdown beside the command includes Merge Across, Merge Cells, and Unmerge Cells. Merge Across merges cells separately across each selected row; it is not the same as turning an entire rectangular selection into one cell. Check the selection and the command name before clicking.

If a warning appears, verify that the upper-left cell already contains the complete text you intend to keep. If the original values have not been combined, cancel the operation and join them first. Once merged, the larger cell is still addressed by its top-left cell reference. For a merged A2:B2 range, formulas and references use A2; B2 is no longer an independent usable cell in that merged area.

For a large worksheet, do not assume every row should be merged in the same way. Merging a multirow selection can leave only the top-left entry of the entire selection, depending on the selected command. If each row contains a separate pair of values, combine and inspect each row separately, then use Merge Across only if that layout is genuinely intended.

When not to merge: better layout alternatives

Merged cells can make headings look tidy, but they often make structured data harder to work with. Sorting, filtering, copying ranges, filling formulas, and using Excel tables can become awkward when the range contains merged cells. A merged heading is usually less troublesome than merging cells in the body of a data table, but a clean, unmerged data area is generally easier to maintain.

Center Across Selection: For a heading that should appear centered over several columns without combining the cells, select the range, press Ctrl+1 on Windows, open the Alignment tab, choose Center Across Selection from the Horizontal list, and select OK. This changes alignment without deleting other cell contents. On Mac, Command+1 opens Format Cells; the dialog’s tabs and options may be arranged differently by Excel version.
Wrap Text: If a long label is being merged only to make it fit, select the cell and choose Home > Wrap Text. Excel can show the text on multiple lines within the existing cell.
Widen the column: Drag the boundary between column headings, or double-click it to AutoFit the column width to its contents. Widening may be preferable when the worksheet needs to remain easy to sort and filter.
Join values but keep the cells: Put a combined label in another column while retaining the original fields. This is often best for records that may later be searched, sorted, exported, or analyzed.

Center Across Selection is especially useful for report titles spanning several columns. Unlike a merge, it does not turn the selected cells into a single cell, so the underlying grid remains intact. If the goal is only visual alignment, try this before merging.

Common problems and how to avoid them

The second value disappeared: The merge retained the upper-left cell and discarded the other entry. If the change is still in the undo history, press Ctrl+Z on Windows or Command+Z on Mac immediately. Otherwise, check version history or a backup; unmerging alone will not restore the value.
The joined text has no space: A formula such as =A2&B2 places the values directly next to each other. Include a quoted separator, for example =A2&" "&B2, and verify the output before pasting it back.
The merged range is the wrong size: Confirm the selected cells before using the merge command. For headings across several columns, a single accidental extra row can cause data in that selection to be discarded too.
Sort or filter behaves unexpectedly: Look for merged cells in the data range. Unmerge them and place headings or labels in a layout that keeps each record in its own row and each field in its own column.
The formula displays an unexpected date or number: Joining turns values into text and may not carry over their cell formatting. Use TEXT with an appropriate format string, then inspect the result.

Frequently Asked Questions

Can I merge two cells in Excel and keep both values?
Not with the merge command alone. Join the contents first, put the combined result in the upper-left cell as a value, and then merge. Otherwise Excel keeps only the upper-left cell’s content.

Does Unmerge Cells bring back deleted data?
No. Unmerge Cells restores the separate cell layout, but it does not recover contents removed by a previous merge. Use Undo if the merge is still recent, or restore an earlier workbook version or backup.

How do I combine cells with a comma between them?
For two values in A2 and B2, enter =A2&", "&B2 in another cell. It joins them with a comma and a space. Check the result before copying it as a value into the cell you plan to keep.

Can I merge cells without centering the text?
Yes. Open the dropdown beside Home > Merge & Center and choose Merge Cells. If you only want text centered across columns without merging, use Format Cells > Alignment > Center Across Selection instead.

Is merging cells the same as combining their text?
No. Merging changes the worksheet layout and retains only the upper-left content. Joining combines values into text, usually with a formula; the cells remain separate unless you subsequently merge them.

Choosing the right approach

Use a merge when a larger visual cell is genuinely needed and the other cells’ contents have already been preserved elsewhere or combined into the upper-left value. Use a joining formula when the objective is to put multiple entries into one readable string. Choose Center Across Selection, Wrap Text, or a wider column when the goal is appearance rather than changing the worksheet structure. Keeping those purposes separate prevents accidental data loss and makes the workbook easier to edit later.

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.