Merge Cells and Keep Both Values in Excel Without Data Loss

In Excel, merging cells keeps only the value in the upper-left cell; any other cell contents in the selection are discarded. To keep both values, combine them in a helper cell first, paste the combined result into the upper-left cell, and then merge the cells.

What Excel Does When You Merge Cells

A merged range behaves like one larger cell for layout and alignment, but it still starts as several individual cells. When you merge a selection that contains more than one entry, Excel displays a warning that merging keeps only the upper-left value and discards the other values. Confirming the merge does not combine those entries automatically.

For example, if A1 contains “North” and B1 contains “Wing,” merging A1:B1 leaves “North” as the visible cell content. “Wing” is removed from the worksheet. The same rule applies if the other cell contains a formula: the formula and its displayed result do not get appended to the upper-left value. A blank cell is different; merging a blank cell with a populated one does not remove another value.

This matters because merging is a formatting and layout operation, not a data-consolidation tool. It is useful for a heading spanning columns, but risky when the selected cells hold separate labels, names, or records. Decide what the final text should say before you merge.

Combine the Values Before Merging

The reliable approach is to create the combined text outside the cells you plan to merge. In the example below, A1 and B1 contain the two original entries, and C1 is an unused helper cell.

Enter the first value in A1 and the second in B1.
In C1, enter a formula that joins the two values with a space between them.
Check that C1 shows the wording and punctuation you want.
Copy C1, select A1, and use Home > Paste > Values. This replaces A1 with the combined text rather than leaving a formula that depends on the cells you are about to merge.
Select A1:B1 and choose Home > Merge & Center ▼ > Merge Cells. Choose Merge & Center instead if you also want the result centered.
Delete the helper cell if it is no longer needed.

With North in A1 and Wing in B1, this formula in C1 returns “North Wing.” After pasting that result as a value into A1 and merging A1:B1, the merged cell displays “North Wing.” Keeping the formula in the helper cell until you have checked the output gives you a chance to correct spacing or add a separator before changing the original cells.

With North in A1, Wing in B1, and C1 available for the helper formula, enter =TEXTJOIN(" ",TRUE,A1,B1) in C1; the result is North Wing.

Choose a Separator That Fits the Content

A space works well for two words, but it is not right for every pair of values. Use a comma and a space for a city and region, a hyphen for a code, or another separator that makes the result easy to read. Check whether the source values already contain spaces or punctuation so the combined text does not end up with doubled separators.

With Portland in A1, OR in B1, and C1 as the helper cell, enter =TEXTJOIN(", ",TRUE,A1,B1) in C1; the result is Portland, OR. TEXTJOIN is available in Excel for Microsoft 365. Its TRUE argument tells Excel to ignore empty cells, which helps avoid an extra separator when one of the source cells is blank.

For a longer selection, TEXTJOIN can join a range and place the same separator between each nonblank entry. For example, a report heading assembled from several cells might need a space between each word. Review the result carefully: joining a range of numbers converts the output to text, so it will not behave like a number you can sum or calculate with.

If the values need a line break instead of a space, use a line-break character as the separator and turn on Wrap Text for the destination. With A1 and B1 holding the two entries and C1 as the helper cell, enter =TEXTJOIN(CHAR(10),TRUE,A1,B1) in C1; the result contains the first entry, a line break, and the second entry. Select the destination cell and choose Home > Wrap Text so both lines can display. The row may need to be made taller.

Merge Cells, Merge Across, and Center Across Selection

Excel offers several alignment options that can look similar but have different effects. In Windows Excel for Microsoft 365, open the Home tab and use the dropdown beside Merge & Center to find the merge commands. Merge Cells combines the selected range into one cell. Merge & Center does that and centers the remaining upper-left content. Neither command combines multiple values for you.

Merge Across creates separate merged cells for each row in a selected multirow range. It can be useful for headings arranged in rows, but it does not preserve every value within each row: only the leftmost value in that row’s selection remains. Check each row before applying it.

If your goal is only to center a heading across columns while keeping the underlying cells separate, Center Across Selection is often safer. Select the range, open Format Cells using Ctrl+1 on Windows or Command+1 on Mac, choose the Alignment tab, and select Center Across Selection in the Horizontal dropdown. This changes the appearance without merging the cells, so the cells remain independently editable and sortable. Center Across Selection does not combine the text; put the complete heading in the first cell and leave the neighboring cells empty.

What Happens to Formulas, Formatting, and Sorting

When Excel merges cells, the surviving content comes from the upper-left cell of the selected range. If that cell contains a formula, the formula remains in the merged cell, while the contents of the other cells are discarded. If you first create a combined result with a formula, pasting it as a value into the upper-left cell makes the final display independent of the helper formula and source cells.

Merging also affects how the worksheet behaves after the operation. A merged range can make it harder to select, copy, fill, or sort a rectangular data table. Sorting and filtering expect a consistent grid; merged cells within the data area can prevent an operation or produce confusing results. Avoid merging cells inside a list that you plan to sort or filter. For a title above a table, keep the merged title in a separate row outside the records.

Formatting can also be uneven. The merged cell displays as one area, but the upper-left cell is the anchor for its content. If borders, fills, or alignment matter, inspect the result after merging and adjust the merged range. Formatting does not restore any discarded text.

Can You Recover Values After Merging?

Unmerging is not a recovery method. Choose Home > Merge & Center ▼ > Unmerge Cells to separate the range again, but Excel does not put the discarded values back into their original cells. Usually, the upper-left entry remains and the other cells are blank.

If you just merged the cells, use Undo immediately—Ctrl+Z on Windows or Command+Z on Mac—to reverse the operation. If you have continued editing, saved, or closed the workbook, recovery depends on whether you have a usable earlier copy, such as a backup or an available version in OneDrive or SharePoint. Do not assume unmerging or reopening the file will reconstruct the missing entries.

For important workbooks, make a copy before changing a large range. You can also inspect the combined helper output before pasting over the original upper-left value. If the source data matters, retain the original columns on a separate sheet or in a backup copy rather than treating a merged display as the only record.

Common Problems and How to Avoid Them

The result has no space: Use a separator in the formula, such as a space or comma-space, and verify the helper cell before pasting.
A formula shows zero or unexpected text: Check whether the source cells contain formulas returning empty strings, numbers with special formatting, or extra spaces. A joined result is text, and it may not preserve a number’s display format.
The second value vanished: If the merge was just performed, use Undo. Otherwise, unmerging will not restore it; look for an earlier file version or backup.
The merged text appears cut off: Widen the column, enable Wrap Text, or adjust the row height. The content may be present even when the cell does not show all of it.
Sorting or filtering is blocked: Unmerge cells in the data area and keep records in a regular grid. Use Center Across Selection for a visual heading instead.

Before merging, confirm the range has the intended shape, that the upper-left cell will contain the final text, and that there are no other entries you need to preserve. A quick check of the entire selection is more dependable than relying on the warning after Excel has already identified a conflict.

Frequently Asked Questions

Can I merge cells in Excel without losing data?
Not by using the merge command alone when more than one selected cell contains content. Combine the entries first, paste the combined result into the upper-left cell, and then merge. Excel otherwise keeps only that upper-left content.

Does unmerging cells bring back the deleted values?
No. Unmerge Cells separates the range but does not restore entries removed during the merge. Use Undo right away if possible, or find an earlier saved version or backup.

Can I keep both values in separate cells and make them look centered together?
Use Center Across Selection from Format Cells > Alignment instead of merging. It changes alignment without combining the cells, though the heading itself should be in the first cell.

Can I join values from more than two cells?
Yes. TEXTJOIN can combine multiple cells or a range with a chosen separator. Inspect the output and paste it as a value into the upper-left cell before merging the range.

Does Merge Across keep every value in each row?
No. For each row it merges, the leftmost value in that row’s selected range is retained; other contents in that row’s range are discarded. Combine the row’s values first if they all matter.

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.