How to Combine Cells in Excel and Keep All Your Data

With “Ada” in A2 and “Lovelace” in B2, enter =A2&" "&B2 in C2 and fill it down to combine the contents with a space. To keep the combined result without relying on a formula, copy the results and use Home > Paste > Paste Values. This joins the cell contents; it is different from merging cells, which can discard data.

Use a formula when you want to preserve every source value and control what goes between them. Keep the original columns until you have checked the results and saved a value-only copy. These steps are for Excel for Microsoft 365 on Windows; the formulas also work in current Excel for Mac and Excel for the web, although ribbon placement can vary slightly.

What You’ll Need

An Excel workbook with the values you want to join, preferably saved as a copy before you change its layout.
An empty column or range for the combined results. Leave the original cells in place while you check the output.
A separator choice, if needed: a space, comma, hyphen, or a line break.

Step-by-Step

Decide what “combine” means for your sheet. If you want the text or numbers from several cells to appear together in one cell, use a formula. If you only want a larger-looking heading area, use Merge & Center only when the other selected cells are empty. Merging is not a safe way to join existing contents: Excel keeps the upper-left cell and can remove contents in the other cells. This guide focuses on joining values while keeping them.
Make room for the result. If the source values are in columns A and B, insert or choose an empty column such as C. Add a clear heading, for example “Full name,” in C1. Do not put the formula over either source column; doing so can replace a value that the formula needs to read. If your data is in a formatted Excel table, add a new table column and enter the formula in its first data row.
Enter a formula for the first row. With the first part in A2 and the second part in B2, enter =A2&" "&B2 in C2. In this HTML display, the ampersands are written as entities; in Excel, type the formula as =A2&" "&B2 using ordinary ampersand characters. The formula joins the two cell values with one space. If A2 contains Ada and B2 contains Lovelace, C2 displays Ada Lovelace. For a comma and space instead, use =A2&", "&B2; with Ada in A2 and Lovelace in B2, the result is Ada, Lovelace.
Choose a separator that suits the data. The text between the quotation marks is inserted literally. For a hyphen, use =A2&"-"&B2; with 2026 in A2 and 11 in B2, the result is 2026-11. To join values with no separator, use =A2&B2. A separator makes the output easier to read, but it becomes part of the combined text, so choose one that will not confuse later sorting or importing.
Handle missing values if rows are not complete. With the first part in A2 and the optional second part in B2, enter =IF(B2="",A2,A2&" "&B2) in C2. If A2 contains Ada and B2 is empty, the result is Ada rather than Ada followed by a stray space. If B2 contains Lovelace, the result is Ada Lovelace. This simple check is useful for optional middle names or unit numbers; adjust the cell references if your source columns differ.
Fill the formula down the rows. Select C2 and drag the small square at the lower-right corner of the cell down through the rows you need. Excel adjusts the references in each row, so the next row uses A3 and B3, then A4 and B4. You can also select the formula cell and the empty cells below it, then use Home > Fill > Down. On Windows, Ctrl+D fills down in a selected range; on Mac, use Control+D. Check that the last row included is the last row of your source data, not an empty row or a total.
Check the results before replacing anything. Review the top, middle, and final rows. Look for missing separators, doubled spaces, unexpected blanks, and values that look different from the source. Formulas update when their source cells change, which is helpful while editing. If the joined values are dates or numbers with special display formats, check the next step before treating the output as final.
Preserve the results as fixed values when appropriate. If you want a result that will not change when the source cells change or are removed, select the completed output range and copy it. Then choose Home > Paste > Paste Values in the destination range, or use the Paste Values option from the right-click menu. This replaces formulas with their displayed results. Confirm that the values are still correct before deleting or hiding the source columns. Keep a copy of the workbook if you may need to revise the combined data later.

Joining numbers and dates can change how they appear because a formula joins the underlying value, not necessarily the exact cell formatting you see. For example, with a customer name in A2 and a date in B2, enter =A2&" "&TEXT(B2,"m/d/yyyy") in C2 to display the name followed by a date such as 3/14/2026 when B2 contains March 14, 2026. The TEXT format controls the date appearance; choose a format that fits your needs. If the source is a number displayed with leading zeros, those zeros may also need to be added with TEXT using a suitable number format.

Common Mistakes

Using Merge & Center to join text. Merge & Center changes the cell layout, but it does not append the contents of the selected cells. If several selected cells contain data, Excel warns that only the upper-left value will remain. Cancel the merge and use a formula in a separate cell instead.

Overwriting the source cells. A formula placed in A2 cannot safely combine A2 with another value, because entering the formula replaces the original A2 contents. Put the result in a separate column. Keep the originals until you have verified the output and pasted values if needed.

Forgetting separators or adding the wrong ones. Joining “North” and “Street” without a separator produces “NorthStreet.” A comma may be useful for a list, but the wrong punctuation can make names or addresses harder to use. Preview a few rows before filling the whole column.

Assuming formatting is carried over. Concatenation produces text. A date may show as a number, and leading zeros in an ID may disappear if the source is numeric. Use TEXT with an intentional format when needed, or store identifiers as text from the start.

Deleting the source before checking. If you remove source cells while the output still contains formulas, the results may change or become errors. Convert to values first, then review the pasted results. Remember that pasting values removes the formulas, so keep the original formula column or a backup if you may need to update the output.

Tips

Use a temporary output column and label it clearly. A heading helps prevent confusion when the sheet is shared or revisited later.
For a name, decide whether you need a space, comma, or “Last, First” order before filling down. You can reverse the references in the formula if the source columns are in the opposite order.
For a line break between two values, with the first value in A2 and the second in B2, enter =A2&CHAR(10)&B2 in C2. Turn on Home > Wrap Text so both lines can display inside the cell. The result contains a line break between the values.
Keep values that are identifiers, such as postal codes or account numbers, in text format when leading zeros matter. A joined result is text, but a zero already lost from a numeric source cannot be restored without knowing the intended format.
After pasting values, consider adjusting the column width or using Home > Wrap Text so the combined text is visible. This changes how the result displays, not the underlying joined content.

Troubleshooting

The formula appears as text instead of calculating: Check that the cell is not formatted as Text. Change it to General using Home > Number Format, then re-enter the formula. Also check that the entry begins with an equals sign and that Show Formulas is not enabled; turn it off from Formulas > Show Formulas if the sheet is displaying formulas throughout.

The result has a number instead of a readable date: Use TEXT in the formula to specify a date format, as shown above. Changing the output cell’s number format alone may not change a date that has already been converted into joined text.

There are extra spaces or blank-looking results: Check the source cells for spaces that were typed before or after the values. The blank-cell IF formula handles an empty B2, but a cell containing a space is not truly empty. Remove unwanted spaces from the source or adjust the formula to account for them.

Only some rows have results: Confirm the fill-down range reaches the final data row and that there are no unexpected gaps in the output column. If the data is in an Excel table, check that the formula was entered in the table’s data column and that the table includes all relevant rows.

You merged cells and lost a value: If the action was just performed, use Undo immediately, then use a concatenation formula in a separate cell. If undo is no longer available, restore the workbook from a saved copy or recover the missing value from another source. A merge does not store the discarded cell contents inside the merged cell.

Frequently Asked Questions

Does Merge & Center combine the contents of cells?
No. It combines the selected cell area into one larger cell, but it does not join all the text. Excel keeps the upper-left cell’s contents and may discard the others. Use a formula to retain multiple values.

Can I combine cells without a space between the values?
Yes. With values in A2 and B2, use =A2&B2. If you want punctuation or a space, include it in quotation marks between the cell references.

Will the combined result update if I edit a source cell?
Yes, while the output is a formula. If you paste the output as values, it becomes fixed text and will not update when the sources change.

Can I join more than two cells?
Yes. With values in A2, B2, and C2, enter =A2&" "&B2&" "&C2 in D2 to join them with spaces. The result is the three values separated by spaces; change the separators if the data calls for commas or another divider.

Can I combine cells on Mac or in Excel for the web?
Yes. The ampersand formulas work in current Excel for Mac and Excel for the web. Ribbon labels or their locations may differ slightly, but look for Paste Values in the Paste options. The Windows shortcut Ctrl+D is Control+D on Mac.

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.