How to Combine Cells in Excel and Keep All Values

To keep every entry, combine the cell contents into a result first, copy that result, and use Paste Values before removing or merging the original cells. Excel’s Merge Cells command by itself keeps only the value in the upper-left cell and discards the rest, so do not use it as the first step.

What You’ll Need

Excel for Microsoft 365 on Windows and a workbook with the cells you want to combine.
An empty helper column or another safe place to build and check the combined results.
A saved copy of the workbook if the original data is important. Merging cells and clearing source cells can be difficult to reverse after further edits.

Step-by-Step

Choose whether you need combined text or a merged layout. Combining contents creates one text string from several cells; for example, it can put a first name and last name together in a single cell. Merging changes the worksheet layout so several neighboring cells appear as one. You can combine values without merging, and that is usually the better choice for data you will sort, filter, or use in formulas. If you need both, make the combined text first and merge only after checking it.
Check the source range and prepare a helper column. For example, suppose A2 contains Mia, B2 contains Chen, and C2 contains Seattle. Put a heading such as “Combined” in D1 and use D2 for the result. Check that D2 and the cells below it are empty; a formula cannot safely fill into cells that already contain information. Keep the original columns until you have verified the result.
Join the cell contents with a delimiter. With Mia in A2, Chen in B2, and Seattle in C2, enter this formula in D2 to join the nonblank entries with spaces: =TEXTJOIN(" ",TRUE,A2:C2). The result is “Mia Chen Seattle.” The first argument is the separator, and TRUE tells Excel to skip empty cells. For a comma and a space instead, use =TEXTJOIN(", ",TRUE,A2:C2); the same sample cells produce “Mia, Chen, Seattle.” TEXTJOIN is available in Microsoft 365 and newer Excel versions, including Excel 2019 and later.
Use a simple alternative for two cells. With a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2. For Mia and Chen, the result is “Mia Chen.” The ampersand joins the contents, and the quoted space adds a separator. This approach works in older Excel versions as well. Change the quoted separator to a hyphen, comma, or other text if that suits your data.
Fill the formula down the rows. If row 2 is your first record and your data continues through row 20, select D2 and drag the small fill handle at its lower-right corner down to D20. You can also copy D2, select D3:D20, and paste. Excel adjusts the row references so D3 joins A3:C3, D4 joins A4:C4, and so on. Check several results, including rows with blanks, before changing the source data.
Turn formula results into fixed values. Once the results are correct, select D2:D20 and copy them with Ctrl+C on Windows (Command+C on Mac). Select the cells where you want the final text to live. To keep the results in the helper column, use Home > Paste > Values. To replace the first source column instead, paste the copied results as values into A2:A20. In Windows, Ctrl+Alt+V opens Paste Special; choose Values and press Enter. On Mac, use Home > Paste > Values if the keyboard shortcut differs in your Excel setup. Pasting values removes the formulas’ dependence on the original cells.
Check before clearing anything. Compare a few pasted results with the source row, and confirm that spaces, punctuation, and blank entries look right. If you pasted into column A, the original A values have been replaced, but B and C still contain their source data. Only after confirming the pasted results should you select B2:C20 and press Delete to clear their contents. Delete removes cell contents; it does not remove the worksheet rows or columns.
Merge the cells only if the layout requires it. For one record, make sure the combined value is in A2 and B2:C2 are blank, then select A2:C2. Choose Home > Merge & Center ▼ > Merge Cells if you want a single wider cell without centering the text. For separate merged cells in each row of a list, put each completed result in the first column, clear the other cells in those rows, select the full range (for example, A2:C20), and choose Home > Merge & Center ▼ > Merge Across. Merge Across merges each row separately. Excel retains the value in the leftmost cell of each row; any remaining content in the selected cells would be lost. Save the workbook when you are satisfied.

Common Mistakes

Clicking Merge before combining the values: Excel warns that merging keeps only the upper-left cell’s content. The warning is literal: other entries in the selected range are discarded. Cancel the merge, use a formula to assemble the contents, and merge only after the result is safely stored.

Overwriting the source too soon: A formula such as TEXTJOIN refers to the original cells. If you clear those cells before copying the result as a value, the formula may return an empty or incomplete result. Keep a helper column and verify the output first.

Forgetting separators: Joining “Mia” and “Chen” with no separator gives “MiaChen.” Choose a space, comma, slash, or other delimiter deliberately. Also check whether blank cells should be skipped or whether blank positions matter to your final text.

Assuming displayed formatting is carried into text: Excel stores dates and many formatted numbers as underlying values. When joined into text, a date can appear as a serial number or a number can lose its commas or leading zeros. Format such entries deliberately before combining them, or use a suitable TEXT formula to specify how they should appear.

Merging data that needs to behave like a table: Merged cells can interfere with sorting, filtering, selecting ranges, and copying records. For a clean data table, keep values in separate columns or use a helper column for the combined text rather than merging cells.

Tips

Use a helper column even if you plan to merge later. It lets you inspect the combined text without damaging the source and makes it easy to redo the formula if the separator or range needs changing. Keep a copy of the original worksheet until you have checked the output.

TEXTJOIN is useful when some cells may be blank because its TRUE argument skips empty cells instead of adding a run of separators. If each piece of information needs a distinct separator, build the result with the appropriate delimiter or combine columns in stages. Make a small test in one row before filling a formula across hundreds of records.

For dates, specify the intended display format before joining. With a date in A2 and a name in B2, use =TEXT(A2,"mmm d, yyyy")&" - "&B2 in C2. If A2 is March 5, 2026, and B2 is Mia, the result is “Mar 5, 2026 – Mia.” The format code controls the date’s text appearance; choose a format that suits your audience.

After pasting values, you may delete the helper column if you no longer need it. If you want to keep the original data, leave the source columns in place and use the combined column as the display or export field. This is often safer than merging cells, especially in shared workbooks.

Troubleshooting

The Merge warning says some data will be lost: Choose Cancel. Return to the formula method, put the combined result in a helper cell, and verify it. Then copy and paste values into the upper-left cell of the range you intend to merge, clear the other cells, and merge. Do not accept the warning if those other cell values are still needed.

The formula displays as text or does not calculate: Check that the cell is not formatted as Text. Change its format to General, edit the formula (press F2, then Enter on Windows), and check that it begins with an equals sign. Also check that calculation is not set to manual if results are not updating; use Formulas > Calculation Options > Automatic.

The combined result has missing spaces or extra punctuation: Review the separator inside the formula’s quotation marks. With TEXTJOIN, TRUE skips empty cells, which avoids extra delimiters for blank entries. If an entry itself contains spaces or punctuation, remember those characters are part of the original value, not added by the formula.

A date or number looks wrong after joining: The formula may be using the underlying value rather than the number format you see in the source cell. Use TEXT with an explicit format for that item, as in the date example above. For identification codes, store the codes as text where possible so leading zeros are not lost before you combine them.

You merged the wrong range: Use Home > Merge & Center ▼ > Unmerge Cells if the cells are still merged. Unmerging restores the separate cells but does not bring back content discarded during the merge. Recover that data from Undo if available, a saved copy, or workbook version history.

Frequently Asked Questions

Can I merge cells in Excel without losing data?
Not with the Merge Cells command alone. It keeps only the upper-left cell’s value. Combine the contents first, paste the result as a value into the upper-left cell, clear the other cells, and then merge if needed.

What is the safest way to combine text from several cells?
Use TEXTJOIN in a helper column, check the result, and paste it as a value if you need a fixed result. This preserves the source cells until you decide they are no longer needed.

Can I combine cells but keep the original columns?
Yes. Put the formula in a new column and leave the source cells unchanged. You do not have to merge anything; the formula result is a separate combined value.

Does Merge Across keep the values in every row?
It merges each selected row separately, but it still keeps only the leftmost cell’s content in each row. Make sure the combined result is in that cell and the other cells in each row are empty first.

Can I undo a merge after saving?
You can unmerge cells, but unmerging does not restore values that were discarded. Use Undo immediately if available, or recover the original data from a saved copy or version history.

Will combining cells preserve date formatting?
Not necessarily. A formula that joins a date with text may show the date’s underlying serial value. Use TEXT with a date format inside the formula to control how the date appears in the combined text.

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.