Excel Merge Cells: Combine Content Without Losing Data

How-to basics · Updated November 19, 2026

No: Excel’s Merge & Center command does not combine the contents of selected cells; it keeps the value in the upper-left cell and discards the other cell contents. To put several values into one cell without losing them, combine them with a formula such as =TEXTJOIN(" ",TRUE,A2:C2), then copy the result and paste it as a value if you need a permanent result.

What Excel’s merge command actually does

In Excel for Microsoft 365 on Windows, select adjacent cells and choose Home > Merge & Center to create one larger cell spanning their space. The command changes the worksheet layout; it does not join the text or numbers stored in those cells. If more than one selected cell contains data, Excel warns that merging keeps only the upper-left value. The other contents are removed from the worksheet.

For example, if A2 contains “Mina,” B2 contains “Chen,” and C2 contains “Design,” merging A2:C2 does not produce “Mina Chen Design.” The merged cell displays “Mina,” and the other values are lost unless you undo the operation or restore them another way. The same rule applies if the cells contain formulas: only the upper-left cell’s content remains.

The dropdown beside Merge & Center includes options such as Merge Cells, Merge Across, and Unmerge Cells. These options affect the arrangement of the cells, not how their contents are combined. Merge Across creates separate merged areas for each row in the selection; it still does not concatenate the values in each row.

Choose the result you actually need

Before changing a worksheet, decide whether you want to combine data or simply change how it looks. Those are different tasks, and choosing the right one prevents accidental loss and makes the workbook easier to use later.

  • Put text from several cells into one value: use a formula such as TEXTJOIN or the ampersand operator.
  • Make a heading look centered across columns: use Center Across Selection, which changes alignment without merging cells.
  • Create one larger cell for a label or title: use Merge & Center only when the selected cells do not contain separate information that must be kept.
  • Keep the combined result but remove its formula: copy the formula result and use Paste Special > Values.

A reliable habit is to preserve the original columns until you have checked the combined output. Once the joined text is correct, you can decide whether to keep the formula, paste a fixed value, or remove the source columns.

Combine cell contents with TEXTJOIN

TEXTJOIN is useful when you want to combine a range and specify what should appear between its values. Its arguments include a delimiter, a setting for whether to ignore empty cells, and the cells or ranges to join. For example, a space delimiter creates readable full names, while a comma and space can separate list items.

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

=TEXTJOIN(" ",TRUE,A2:C2)

If the cells contain “Mina,” a blank, and “Chen,” the result is “Mina Chen.” The TRUE argument tells Excel to skip empty cells, so the blank middle-name cell does not create an extra space. If every cell has a value, the same formula joins each value with one space.

To produce a comma-separated list, use a different delimiter. With the items “Apples,” “Pears,” and “Plums” in A2:C2, this formula returns “Apples, Pears, Plums”:

=TEXTJOIN(", ",TRUE,A2:C2)

TEXTJOIN is available in Microsoft 365 and supported newer Excel versions. If you need compatibility with older software, the ampersand operator is a basic alternative for joining a known set of cells. Whichever approach you use, the formula result appears in the cell where you entered the formula; it does not merge the source cells.

Use the ampersand for a simple combination

For a small, fixed set of cells, the ampersand operator is straightforward. With a first name in A2 and a last name in B2, enter this formula in C2:

=A2&" "&B2

If A2 is “Mina” and B2 is “Chen,” the result is “Mina Chen.” The quoted space is a text value between the two references. You can use a comma, hyphen, or other separator instead by changing the text inside the quotation marks.

The ampersand is less convenient when joining a long range or when blank cells should be skipped automatically. A direct formula that includes a space for every cell can leave extra spaces if some cells are empty. TEXTJOIN handles a range and can ignore blanks, making it a more practical choice for lists of names, addresses, or labels.

Handle dates, numbers, and line breaks

When a formula joins a date or number with text, Excel may show the underlying number rather than the display format you see in the original cell. Dates are stored as serial numbers, and number formatting in a source cell is not necessarily carried into the joined text. Use TEXT when the combined result needs a specific date or number appearance.

With a name in A2 and a date in B2, this formula displays the date in a readable month-day-year format:

=A2&" — "&TEXT(B2,"mmm d, yyyy")

If A2 contains “Mina” and B2 contains April 15, 2026, the result is “Mina — Apr 15, 2026.” The format code inside TEXT controls the date’s appearance; it does not change the date stored in B2. You can use another format code if the workbook calls for a different style.

For an address or other value that should appear on separate lines inside one cell, use a line break as the delimiter. With address parts in A2:C2, this formula joins nonblank parts with line breaks:

=TEXTJOIN(CHAR(10),TRUE,A2:C2)

Turn on Home > Wrap Text for the result cell so the line breaks display on separate lines. You may also need to adjust the row height. This creates one cell containing multiple lines of text; it does not create multiple worksheet rows.

Keep the result or keep it linked to its sources

A formula-based combination updates when its source cells change. That is useful for a live report, but it also means the result depends on those source cells and the formula remaining in place. If you delete or overwrite a source value, the combined text changes too.

To make the result independent, first check that it is correct. Then copy the formula cell and choose Home > Paste > Paste Special > Values. This replaces the formula with its current displayed value. You can then remove the original columns if they are no longer needed, but keeping a backup copy is wise when the source data matters.

For a large range, fill the formula down alongside the records rather than merging rows or columns. For example, put a combination formula in D2 and use the fill handle to copy it down for subsequent rows. Check a few results, including records with blank fields, before treating the output as complete.

Why merged cells can cause worksheet problems

Merged cells are sometimes suitable for a simple report title, but they can make ordinary data tasks awkward. A merged area has a single upper-left cell and spans the other selected cell positions. As a result, sorting, filtering, copying, pasting, selecting ranges, and filling formulas may behave differently than expected, especially when merged and unmerged cells are mixed in a data table.

They can also make a worksheet harder to maintain. A column of records usually works best when each field has its own cell and each row has the same structure. Merging cells inside such a table can interfere with sorting and filtering, and Excel tables do not support merged cells within their data area. Screen readers and other assistive technologies may also find irregular layouts harder to interpret.

For these reasons, avoid merging cells inside data lists that people need to sort, filter, analyze, or import into another system. Keep names, addresses, and other individual fields in separate columns, and create a combined display in a separate output column when needed.

Use Center Across Selection for a heading

If your goal is only to center a heading across several columns, Center Across Selection often gives you the appearance of a merged heading without actually joining the cells. The heading remains in the leftmost cell, and the neighboring cells remain independent. This is generally more flexible for later editing and worksheet operations.

On Windows, select the cells across which the heading should appear, open the Format Cells dialog with Ctrl+1, and go to the Alignment tab. In the Horizontal list, choose Center Across Selection and select OK. On a Mac, open Format Cells from the Format menu and use the Alignment settings; keyboard shortcuts can differ by keyboard and Excel configuration.

This setting changes alignment only. It does not combine values, and it is not a substitute for TEXTJOIN when the goal is to create one text value. If you need to edit the heading, edit the leftmost cell in the selected range.

Recover data after an accidental merge

If you have just merged cells and notice that values disappeared, press Ctrl+Z on Windows immediately to undo the merge. On a Mac, use Command+Z. Undo is the simplest recovery when the merge is still the most recent action. If you have made more changes since then, undoing may also reverse those later actions, so review the workbook before continuing.

After saving, closing, or performing enough other actions, undo may no longer restore the original contents. Excel does not store the removed cell values inside the merged cell. Look for an earlier saved copy, a version in OneDrive or SharePoint version history if the workbook is stored there, or the original source data. If the values were important, do not continue editing the only copy until you have checked recovery options.

Frequently Asked Questions

Can Excel merge cells and keep all the text?
No. Merge & Center retains the upper-left cell’s contents and removes the contents of the other selected cells. Use TEXTJOIN or a concatenation formula to put the values together in one cell instead.

What formula combines cells with a space between them?
For values in A2:C2, use =TEXTJOIN(" ",TRUE,A2:C2). It inserts spaces between nonblank values and ignores empty cells.

How do I combine cells without a formula in the final result?
Combine them with a formula, check the output, then copy the result and use Paste Special > Values. The final cell contains fixed text rather than a formula linked to the original cells.

Can I unmerge cells and get the deleted text back?
Unmerge Cells restores the original cell layout, but it does not recover values that were discarded during the merge. Use Undo if available, or restore the data from a saved copy or version history.

Does Merge Across combine the text in each row?
No. Merge Across merges cells row by row but does not join their contents. Use a separate formula for each row if you want a combined text result.

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.