To merge cells in Excel without losing their text, first combine the contents into one cell, then copy that combined result back into the upper-left cell and merge. Excel’s Merge Cells command keeps only the upper-left cell’s content; text in the other selected cells is discarded. The steps below use Microsoft Excel for Microsoft 365 on Windows and include notes for Mac and Excel for the web.
What You’ll Need
- An Excel workbook with the cells you want to merge. Save a copy first if the existing entries are important; merging can remove content from cells other than the upper-left one.
- A blank cell outside the range you plan to merge. You’ll use it to combine the text before placing the result in the merged cell.
- Excel for Microsoft 365, or another Excel version that supports the
TEXTJOINfunction. If that function is unavailable, you can combine cells with the ampersand method described in the steps.
Step-by-Step
- Check the range and decide how to separate the text. Identify every cell whose contents must be kept, and note the order in which you want the entries to appear. For example, if A2 contains “North,” B2 contains “Region,” and C2 contains “Office,” you might want the finished cell to read “North Region Office.” Decide whether spaces, commas, a dash, or line breaks will make the combined result easiest to read. Make sure the cell where you’ll build the result is outside the range you intend to merge.
- Combine the contents in a helper cell. For a row with values in A2:C2, enter this in an unused cell such as D2:
=TEXTJOIN(" ",TRUE,A2:C2). The formula joins nonblank cells with a space, so the example returns “North Region Office.” The first argument supplies the separator; TRUE tells Excel to skip blank cells; and A2:C2 is the source range. If you want commas and spaces instead, use=TEXTJOIN(", ",TRUE,A2:C2). If you want each entry on a separate line, use=TEXTJOIN(CHAR(10),TRUE,A2:C2), then turn on Home > Wrap Text for the final cell. TEXTJOIN does not alter the original entries, so you can inspect its result before proceeding. - Use an alternative if TEXTJOIN is unavailable. For two cells with text in A2 and B2, type
=A2&" "&B2in a blank cell. With “North” in A2 and “Region” in B2, the result is “North Region.” For three cells, extend the pattern as=A2&" "&B2&" "&C2. This approach is straightforward for a short range, but you must add each cell and separator yourself. Check that the result includes every entry, especially when some cells are blank. - Check the combined result before merging. Read the helper cell from beginning to end and confirm that the words are in the intended order and the separators look right. If the text is cut off in the cell display, click the helper cell and check the formula bar; the visible column width may be the only issue. If a date, time, or number appears in an unexpected format, address that before continuing. A formula joins underlying cell values and does not reliably carry over each source cell’s number format, font, color, or other rich formatting.
- Copy the finished result into the upper-left cell of the range. Select the helper cell and copy it with Ctrl+C on Windows or Command+C on Mac. Select the upper-left cell of the range you want to merge—in the example, A2. Use Home > Paste > Paste Values so the combined text is placed there as a fixed value rather than as a formula referring to the cells you are about to merge. The wording in A2 should now be “North Region Office.” You can also use the Paste Values option from Excel’s context or paste menu if it appears in your version.
- Select only the cells you intend to merge. For the example, select A2:C2. Confirm that the combined text is in A2, the upper-left cell. Don’t include the helper cell D2. If you’re preparing several rows, handle each row’s combined result separately and make sure each row’s result is in its own leftmost cell before merging. Selecting a rectangle across several rows and choosing Merge Cells creates one large merged area, not a separate merged cell for each row.
- Merge the selected cells. On Windows, open Home and use the arrow beside Merge & Center to choose Merge Cells. Choose Merge & Center only if you want the result centered; it also merges the selection. On Mac, use the Home tab’s Merge & Center dropdown and choose Merge Cells. Excel for the web also provides merge choices on the Home tab, though the ribbon layout can vary with window size. If Excel warns that only the upper-left value will be kept, confirm only after checking that the combined text is already in that cell.
- Review the finished cell and tidy the sheet. Click the merged cell and verify its full contents in the formula bar. Use Home > Wrap Text if you need the text to display on multiple lines, and adjust row height or column width if necessary. Once you are satisfied, you may delete the helper formula cell. Keep it until you have checked the merged result, and remember that deleting it is optional.
Common Mistakes
Merging before combining the contents is the most serious mistake. Excel does not automatically join text from all selected cells. It retains the value in the upper-left cell and removes the contents of the other cells in the merged range. Unmerging afterward does not bring those removed entries back, so do not rely on Unmerge Cells as an undo method.
Putting the helper formula inside the range to be merged can create a circular reference or cause the formula itself to be discarded. Put the formula in a genuinely separate blank cell, review its result, and paste that result as a value into the range’s upper-left cell before merging.
Choosing Merge & Center when you only want a merge can change the alignment unexpectedly. Use the dropdown and choose Merge Cells to retain the current alignment. Also note that Center Across Selection is a different formatting option, not a merge; it can center a label across cells without combining them and is often better when the cells need to remain separate for sorting or formulas.
Selecting several rows at once without considering the result can create one large merged cell rather than separate merged cells for each row. If the goal is one merged cell per row, combine and merge each row individually, or use Merge Across only after confirming that each row’s leftmost cell already contains all of its row’s text. Merge Across retains the leftmost value in each row and can discard the other values in that row, so prepare those values first too.
Expecting formatting to be combined along with text can lead to surprises. A join formula creates text; it does not preserve individual font styles, colors, hyperlinks, or number formats from every source cell. Plan to apply a single format to the finished cell, and check dates or currency values before replacing the original contents.
Tips
- Keep a backup or duplicate worksheet until you have verified the merged results. This is especially useful when the range contains many records or information that would be difficult to recreate.
- Choose a separator that makes the combined text understandable. Spaces work for ordinary words; commas work for lists; a line break works for labels or addresses that are easier to read on separate lines.
- If you want line breaks in the result, use
=TEXTJOIN(CHAR(10),TRUE,A2:C2)with source text in A2:C2, paste the result as a value into A2, and apply Home > Wrap Text after merging. Increase the row height if all lines are not visible. - For a heading that only needs to look centered over multiple columns, consider selecting the cells and applying Center Across Selection from the Format Cells alignment options instead of merging. Keeping cells separate makes many later tasks, such as sorting and selecting individual columns, easier.
- When working with repeated rows, verify a completed row before continuing. Check that the helper formula references the correct row each time, that the combined value is in the leftmost cell, and that the selection does not include neighboring data.
Troubleshooting
Some text disappeared after merging. First, press Ctrl+Z on Windows or Command+Z on Mac immediately, if the merge is still the most recent action. Undo may restore the previous cells, but if more edits have been made, it may undo those edits too. If undo is no longer available, recover the entries from your saved copy, a version in OneDrive or SharePoint, or another source. Unmerging alone will not restore discarded content.
The formula displays an error or is not recognized. Confirm that the formula is entered in a blank cell and that the cell references are correct. In Microsoft 365, =TEXTJOIN(" ",TRUE,A2:C2) is valid Excel syntax. If your Excel version does not recognize TEXTJOIN, use the ampersand approach for the cells you need to combine, or use a newer Excel version. If your regional settings use semicolons rather than commas between formula arguments, use the separator Excel expects in your installation.
The final cell looks blank or the text seems clipped. Click it and inspect the formula bar to see whether the value is present. Turn on Home > Wrap Text, widen the column, or adjust the row height. Merging can affect how text is displayed, and a narrow merged area may not show the entire value at once. The text may still be present even when the cell display is incomplete.
Excel displays a warning about keeping only the upper-left value. Cancel if you have not yet combined the text. Create and check the helper result, paste it as a value into the upper-left cell, then select the range and merge again. If the combined result is already in the upper-left cell and you have confirmed it includes every entry, you can proceed.
Sorting or filtering stops working as expected afterward. Merged cells can interfere with sorting, filtering, and table layouts, especially when merged areas have inconsistent sizes. If the data is a list or table, unmerge the cells and keep the combined text in one ordinary cell instead. Use merging mainly for presentation headings or labels rather than for records that need to be analyzed.
Frequently Asked Questions
Can I merge cells in Excel and keep every entry automatically?
No. Merge Cells does not automatically concatenate the contents. Combine the entries first with TEXTJOIN or a suitable ampersand formula, paste the result as a value into the upper-left cell, and then merge.
Which cell’s text does Excel keep when I merge?
Excel keeps the value in the upper-left cell of the selected range. For a horizontal range such as A2:C2, that is A2. For a vertical range such as A2:A4, it is also the top cell, A2.
Can I preserve blank cells without extra spaces?
Yes. In Microsoft 365, the TRUE argument in =TEXTJOIN(" ",TRUE,A2:C2) tells Excel to ignore blank cells. That avoids repeated separators for empty cells in the source range.
Will merging keep the original formatting in every cell?
No. A merged area has one cell’s content and a single set of cell formatting. A formula used to combine text does not bring together different fonts, colors, or number formats. Apply the desired formatting to the merged cell after the text is safely combined.
Can I merge cells without centering the text?
Yes. On the Home tab, open the arrow beside Merge & Center and choose Merge Cells. That merges the selection without applying the centering action. You can set alignment separately afterward.
Does this process work in Excel for Mac and Excel for the web?
The same basic method works in both: combine the contents, place the result in the upper-left cell as a value, and then use the Home tab’s merge options. Mac uses Command+C to copy where Windows uses Ctrl+C. Ribbon placement and available paste choices can vary slightly by version and window size.
Related
- Excel Sum Text? What SUM Does With Text Cells
- How to Remove Duplicates in Excel Safely, Step by Step
- Remove Duplicates in Excel by Entire Row: A Safe Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Outlook Cache on a PC: Safe Steps for WindowsTo clear Outlook cache on a Windows PC, first choose the cache that matches the problem: in classic…
- How to Make a Digital Poster in PowerPoint That WorksTo make a digital poster in PowerPoint, set the slide to the proportions and size your destination needs,…
- Power Query Merge: How to Join Tables in Microsoft ExcelPower Query Merge joins rows from two queries using one or more matching columns. In Excel, open the…
- Can You Merge Cells in Excel? Options and LimitsYes, you can merge cells in Excel for Microsoft 365 on Windows: select the cells, then choose Home…
- How to Insert a Checkbox in Word Online: Clickable or NotIn Word for the web, select the lines you want to turn into a list, then choose Home…
- Google Sheets IF OR: How to Test Multiple ConditionsTo use IF with OR in Google Sheets, put OR inside the IF condition: =IF(OR(A2="Open",B2>=100),"Review",""). This returns “Review”…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.