How to Merge Cells in Excel and Keep All Text

To merge cells in Excel and keep all their text, first join the contents with a formula such as =TEXTJOIN(" ",TRUE,A2:C2), paste the result as a value into the top-left cell, and then merge the range. Excel’s merge command keeps only the top-left cell’s content; it does not combine the other cells for you. Save a copy of the workbook before changing important data, because merging can discard contents.

The steps below are for Excel for Microsoft 365 on Windows. The same approach works in current Excel for Mac and Excel for the web, although button placement can vary slightly. If you only want text to look centered across cells, without actually merging them, use Center Across Selection instead; that preserves the individual cell values.

What You’ll Need

A workbook with the cells you want to combine. Identify the full range and decide which cell should hold the finished text; for a merged range, that is normally the top-left cell.
An empty helper cell outside the range, such as D2 when your source text is in A2:C2. The helper is where you will join the text before replacing the original top-left value.
A backup of the workbook or a copy of the source values, especially if the data is important. Once a merge discards cell contents, unmerging will not bring them back.

Step-by-Step

Check the range and make a backup. Select the cells you plan to merge and note their order. For example, if A2 contains North, B2 contains Region, and C2 contains 2026, the range is A2:C2. Confirm that you are joining the intended cells and that there are no hidden values farther down or across the selection. Save a separate copy of the workbook, or copy the original range to an unused area before proceeding.
Choose a separator for the combined text. A space works for words that should read naturally as one phrase. Use a comma and a space for items such as city and state, or a dash for a label and code. If you want each original cell’s text on a separate line inside the final merged cell, use a line break as the separator instead. Choosing this now helps avoid a combined result with words running together.
Join the source cells in an empty helper cell. With text in A2:C2 and an empty helper cell in D2, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2 and press Enter. This joins the cell contents in order, inserts a space between nonblank entries, and ignores blank cells. With North in A2, Region in B2, and 2026 in C2, the displayed result is North Region 2026. If your source range is different, replace A2:C2 with that range and put the formula in a cell outside it.
Review the joined result before replacing anything. Check the helper cell for missing text, unwanted spaces, or a separator that does not suit the contents. TEXTJOIN combines cell values, not necessarily their visual formatting. For example, a date or a number with a custom number format may not appear in the joined text exactly as it did in its original cell. If that matters, make the desired date or number text explicit before joining, or edit the result in the helper cell while the originals are still available.
Copy the result into the top-left cell as a value. Select D2 and copy it with Ctrl+C on Windows (Command+C on Mac). Select A2, the top-left cell of the range, then use Home > Paste > Paste Values. On Mac, use the Paste Values command on the Home tab if it is shown in the ribbon or paste options. Pasting a value is important: it replaces the formula with its result, so the final text does not depend on cells that you are about to merge. Verify that A2 now displays North Region 2026.
Select the cells to merge. Select A2:C2 again. Do not include the helper cell D2. If you have joined a larger rectangular range, select that full rectangle, with the combined value already placed in its top-left cell. Excel cannot merge separate, nonadjacent selections in one operation.
Merge without changing the alignment by accident. On the Home tab, open the drop-down beside Merge & Center and choose Merge Cells. This merges the selected cells but does not apply the centering action implied by the main Merge & Center button. If centered text is what you want, choose Merge & Center instead. Excel may show a warning that only the upper-left value will be kept; because you placed the complete joined text there first, confirm the warning after checking the selection.
Check the finished cell and clean up. Confirm that the merged cell shows the complete text and that the text fits. Turn on Wrap Text from Home if you want a long result to display on multiple lines, and adjust the row height if needed. Once you are satisfied, clear the helper formula in D2 if it is no longer needed. Keep a copy of the original cells until you know you will not need them.

For a line break between entries, use the same source layout—text in A2:C2 and an empty helper cell in D2—but enter =TEXTJOIN(CHAR(10),TRUE,A2:C2). With North, Region, and 2026 in the source cells, the result places each nonblank item on its own line. Turn on Wrap Text for the merged cell so the line breaks are visible. The Windows copy shortcut is Ctrl+C and the Mac equivalent is Command+C; the same difference applies to Ctrl+Z and Command+Z for undoing an action before you continue.

Common Mistakes

Merging before joining the text. Excel normally keeps only the upper-left cell’s value and removes the contents of the other selected cells. If you merge first, unmerging will not restore the removed text. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the merge just happened, then combine the contents before merging.
Putting the helper formula inside the range. A formula placed in one of the source cells can be overwritten or create a circular reference. Use an empty cell outside the range, and make sure it will not be included in the final selection.
Choosing Merge & Center when you only want Merge Cells. The main button may both merge and center the result. If you do not want centered text, use the drop-down and choose Merge Cells. You can also change the alignment afterward from the Home tab.
Expecting a merge to preserve every cell’s formatting or value type. The merged cell has one displayed value and one cell location: the top-left. A formula can join contents, but it does not combine separate font styles, number formats, comments, or other cell-level properties into a single equivalent format.
Merging cells inside an Excel table. Excel does not allow merged cells within a formatted table. If merging is essential, first make a copy, then use Table Design > Convert to Range and confirm. This removes the table’s structured behavior, so consider whether a heading outside the table or Center Across Selection is a better choice.

Tips

Keep the combined result in the top-left cell, even when the selection covers several rows or columns. That is the cell Excel retains after a merge. If you need to combine a rectangular range rather than a single row, change the formula’s range accordingly and place the helper outside the entire rectangle. Review the result before pasting it over the top-left value.

If the goal is visual layout rather than making one larger cell, try Home > Format Cells, open the Alignment tab, and set the Horizontal option to Center Across Selection. It can make a heading appear centered over a group of columns while leaving each cell separate. Keeping cells separate is often better for sorting, filtering, copying data, and using formulas.

For repeated rows, join each row in a helper column, then paste each result as a value into that row’s first cell before merging each row’s range. Do not select several rows and assume Merge Cells will create one merge per row; use Merge Across if you specifically want a separate merge in each row. Check the preview and selection carefully, because Merge Across operates row by row and may not create the single large block you intended.

When the text is long, turn on Wrap Text and adjust the row height rather than inserting extra spaces to force the layout. For a clean backup, copy the source range and use Paste Values in a spare area or a separate worksheet. This preserves a simple record of the original contents without keeping formulas that might change later.

Troubleshooting

The warning says some content will be lost: Cancel if you have not already put the joined text in the top-left cell. Create the helper result, paste it as a value into the top-left cell, then select the range and merge. If you already confirmed the warning, undo immediately if possible; otherwise, restore the source from your backup.
The formula shows an error or does not calculate: Check that the formula begins with an equals sign, that the referenced range is correct, and that the helper cell is outside that range. TEXTJOIN is available in Excel for Microsoft 365. If the formula appears literally in the cell, change the cell format from Text to General, then enter the formula again.
The merged cell looks blank or text is hidden: Check that the combined result was pasted into the top-left cell before merging. Then check the font color, horizontal alignment, Wrap Text setting, and row height. A very narrow column or short row can make text difficult to see even when the value is present.
The text has no spaces or has too many separators: Choose the delimiter to match the content. A space is suitable for words; a comma and space may suit a list. Because the example formula ignores blank cells, it does not add separators for empty cells, but spaces already present inside the original cell values remain.
The merge command is unavailable: Confirm that the selection is not inside an Excel table and that the worksheet is not protected against formatting changes. Convert the table to a range only if that is appropriate, or ask for the sheet protection to be changed if you are authorized to do so.

Frequently Asked Questions

Can Excel merge cells without losing the other cells’ text?
No. The built-in merge command keeps the upper-left cell’s content and discards other selected cell contents. Join the text and paste the result into the top-left cell before merging.

Can I keep the cells separate but make them look merged?
Yes. Use Center Across Selection in Format Cells > Alignment. It centers the content visually across selected cells without merging them, which is usually preferable when you need to sort or filter the data.

Will unmerging recover text that Excel removed?
No. Unmerge Cells separates the merged area again, but it does not recover values that were discarded during the merge. Use Undo immediately after an accidental merge or restore the data from a backup.

Can I merge cells with different formulas?
You can join the displayed results by referencing those cells with TEXTJOIN, then paste the joined result as a value into the top-left cell. The merged cell will contain the combined text, not the separate original formulas.

Does this work in Excel for Mac or Excel for the web?
The basic process is the same: join the contents, place the result in the top-left cell, then merge. Ribbon layouts can differ, and Mac uses Command+C and Command+Z where Windows uses Ctrl+C and Ctrl+Z. Excel for the web also provides merge options on the Home tab.

What if the cells contain dates or formatted numbers?
Check the joined result before pasting it over the original. A joined value may not retain the original cell’s display format. If the exact date or number appearance matters, convert or format that value as text before joining, then confirm the output in the helper cell.

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.