In Excel, merging cells joins a selected area into one larger cell, but it does not combine the text inside those cells; Excel keeps only the value in the upper-left cell. To combine text without losing data, use a formula such as =A2&" "&B2 instead. The right choice depends on whether you want a visual layout change or a single text result.
What merging cells does in Excel
Merge is a formatting and layout feature. It combines a group of adjacent cells into one larger cell, which can be useful for a heading centered over several columns. It does not join the separate entries into a sentence, and the merged area still behaves like a single cell for editing and selecting.
For example, if A1 contains Monthly and B1 contains Sales, merging A1:B1 does not produce Monthly Sales. Excel retains the content from A1 and removes the content from B1 after warning you that only the upper-left value will be kept. If the other cells contain information you need, cancel the merge and combine their contents with a formula first.
Excel for Microsoft 365 on Windows offers these commands on the Home tab, in the Alignment group:
- Merge & Center merges the selected cells and centers the remaining content.
- Merge Across merges cells across each selected row separately. Selecting A1:C3 creates one merged cell for each of the three rows.
- Merge Cells makes the selection one cell without centering its content.
- Unmerge Cells removes the merged layout.
On Excel for Mac, the corresponding merge controls are also on the Home tab. The labels and ribbon arrangement can vary slightly by version, but the distinction between merging and combining text is the same.
How to merge cells safely
Before merging, check the entire selected range, not just the cell that appears most prominent. Only the upper-left cell’s content survives. If you are unsure whether other cells contain data, inspect them or make a copy of the worksheet. A merge warning is a useful safeguard, but it cannot restore values that were discarded after you confirm.
- Select the adjacent cells you want to turn into one larger cell.
- Choose Home > Merge & Center, or open its dropdown and select Merge Cells or Merge Across.
- Read Excel’s warning if more than one selected cell contains content. Choose Cancel if you need to preserve all entries.
- Apply any additional formatting, such as bold text, a fill color, or alignment.
To undo a merge later, select the merged area and choose Home > Merge & Center > Unmerge Cells. Unmerging restores the original cell grid, but it does not bring back values that were deleted when the cells were merged. The surviving content remains in the upper-left cell; the other cells are blank. This is why unmerging is not a recovery method for lost text.
How to combine text with a formula
For data you want to join, use a formula rather than the Merge command. The ampersand operator, &, joins text values and is a straightforward choice for names, labels, and other short combinations. It leaves the original cells in place, so you can edit the source values and have the result update.
With a first name in A2 and a last name in B2, enter this formula in C2 to put one space between them: =A2&" "&B2. If A2 contains Ada and B2 contains Lovelace, C2 displays Ada Lovelace. The spaces inside the quotation marks are literal text; without them, the result would be AdaLovelace.
To combine three fields, add another ampersand and a separator where it belongs. With a city in A2, a comma and state abbreviation in B2, this formula creates a familiar location label in C2: =A2&", "&B2. If the cells contain Boston and MA, the displayed result is Boston, MA. You can use a hyphen, slash, or other separator in the same way.
After entering a formula, press Enter. To use it for other rows, drag the fill handle at the cell’s lower-right corner down the column, or copy and paste the formula. Excel adjusts relative references as it fills: a formula referring to A2 and B2 becomes one referring to A3 and B3 on the next row.
CONCAT and TEXTJOIN for multiple cells
Microsoft 365 also includes functions designed to join text. CONCAT joins text from multiple cells or ranges, but it does not add separators automatically. With a first name in A2 and a last name in B2, enter =CONCAT(A2," ",B2) in C2; Ada and Lovelace produce Ada Lovelace. This gives the same result as the ampersand example, with the pieces listed as function arguments.
TEXTJOIN is especially useful when you need the same delimiter between several values or want to skip empty cells. With A2 containing Ada, B2 blank, and C2 containing Lovelace, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2. The result is Ada Lovelace: the first argument supplies a space, and TRUE tells Excel to ignore empty cells. If you set that argument to FALSE, blank cells are not ignored, which can leave extra separators.
To join values with a comma and a space, change the delimiter to ", ". With three nonblank items in A2:C2, the formula =TEXTJOIN(", ",TRUE,A2:C2) in D2 returns, for example, North, Central, South. CONCAT and TEXTJOIN are available in current Microsoft 365 Excel; if a workbook must be used in an older Excel release, check that release’s function support before sharing it.
Combining dates, numbers, and text
Numbers and dates need a little care. When a formula joins a number with text, Excel may display the underlying numeric value rather than the number format you see in its source cell. For dates, that can mean a serial number appears in the combined result instead of a readable date. Use TEXT to specify the display format as part of the formula.
With a person’s name in A2 and a real Excel date in B2, enter =A2&" — "&TEXT(B2,"mmm d, yyyy") in C2. If A2 contains Ada and B2 contains the date 4/10/2026, the result is Ada — Apr 10, 2026. The format code controls how the date is shown: for example, "yyyy-mm-dd" produces a year-month-day display. The formula changes the text result’s appearance; it does not change the value stored in B2.
For quantities, choose a number format that suits the intended output. For instance, a price may need two decimal places, while a count may not. If you combine values for a report or export, think about whether the result is meant for display or further calculation: once a number is embedded in a text string, the combined result is text, not a numeric total.
How to choose between merging and combining
Use merging when the goal is visual: a worksheet title spanning several columns is a typical example. Use a formula when the goal is informational: making a full name from first and last names, building an address label, or creating a readable identifier. These operations solve different problems, even though both can make content appear to occupy a wider area.
- Choose Merge & Center for a decorative heading when the cells to be merged do not contain separate values you need.
- Choose an ampersand, CONCAT, or TEXTJOIN when you need the actual values joined into one result.
- Keep source columns separate if you need to sort, filter, calculate, or reuse their individual values later.
- Use a formula result or a copied value for a final report, depending on whether the result should update when its source changes.
A combined formula result is not the same as replacing the source data. You can retain the original columns and use the combined column for display, or copy the results and use Home > Paste > Values when you need fixed text rather than formulas. Keep a copy of the source data if you may need to revise the combination later.
Common problems and better alternatives
A frequent mistake is merging cells because the aim is to combine their contents. That can discard information. If you already merged a range and confirmed the warning, unmerging will not recover the removed values; use a workbook copy, backup, or version history if one is available. Do not assume the merge can be reversed as though it were a normal text formula.
Merged cells can also make routine worksheet work harder. They may interfere with sorting, filtering, selecting ranges, or filling formulas consistently, and Excel tables are designed around one value per cell rather than merged areas. Avoid merges in the middle of a data list or a table. Keep headings in separate cells above the data, or use formatting that does not change the cell structure.
For a heading that should look centered over several columns without combining those cells, consider Center Across Selection. Select the cells, open the Format Cells dialog, choose the Alignment tab, and select Center Across Selection in the Horizontal alignment list. This centers the text across the selected area while leaving the individual cells unmerged. It can preserve a more usable grid, although the text itself still lives in the leftmost cell.
Another alternative is to widen a column, wrap text, or adjust alignment instead of merging. These options can preserve a worksheet’s regular structure. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 opens the formatting dialog. Ribbon shortcuts for merge commands can differ by keyboard layout and Excel version, so the Home tab is the dependable route if a shortcut is unfamiliar.
Frequently Asked Questions
Does merging cells combine their text?
No. Merging changes the layout and keeps only the upper-left cell’s content when other selected cells contain values. To combine text, use &, CONCAT, or TEXTJOIN, choosing a separator if one is needed.
How do I merge cells without losing data?
Do not confirm a merge over cells whose separate contents matter. First combine the text with a formula and verify the result, or keep the values in separate cells. Excel’s merge feature itself does not preserve every cell’s content inside the merged cell.
Can I undo a merge and get the deleted text back?
Unmerge Cells restores the grid but not values discarded during the merge. If the merge was just performed, Undo may reverse the recent action; after that is no longer available, look for a saved copy or version history rather than relying on unmerge.
Which formula skips blank cells when joining text?
TEXTJOIN can ignore blanks. Give it a delimiter, TRUE for the ignore-empty argument, and the cells or range to join, as in =TEXTJOIN(" ",TRUE,A2:C2). This avoids a separator for an empty cell in the range.
Why does a joined date look like a number?
Excel stores dates as numeric serial values, and joining a date with text may expose that underlying value. Wrap the date reference in TEXT and provide a format, such as TEXT(B2,"mmm d, yyyy"), inside the joining formula.
Related
- Excel Print Area Lines: How to Hide Them Correctly
- Excel Hide Row and Column Labels: Steps and Options
- Excel: How to Hide Columns With No Data Automatically
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut to Hide a Column on Windows and MacIn Excel for Microsoft 365 on Windows, select a cell in the column—or select its column header—and press…
- How to Add a Picture to a Cover Page in Microsoft WordTo add a picture to a Word cover page, open the first page, choose Insert > Pictures >…
- How to Split Text Into Columns in Google Sheets EasilyTo split text in Google Sheets, select the cells, choose Data > Split text to columns, then pick…
- Row Example in Excel: How Rows Work and How to Use ThemIn Excel, a row is a horizontal line of cells identified by a number along the left edge;…
- Find Year in Excel: Extract a Year from a DateTo find the year in an Excel date, enter =YEAR(A2) in an empty cell, replacing A2 with the…
- MS Outlook Out of Office: How to Set It UpTo set an out-of-office reply in Microsoft Outlook for Microsoft 365 on Windows, open Outlook and select File…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.