How to Combine Cells in Excel Into One Cell Easily

To combine the contents of Excel cells into a new cell, join them with the ampersand operator (&) or use TEXTJOIN; to turn several cells into one larger cell, select them and choose Home > Merge & Center. These are different actions: formulas preserve the original entries, while merging keeps only the upper-left cell’s content. Decide which result you need before you start.

What You’ll Need

A workbook in Microsoft Excel for Microsoft 365 on Windows, with the cells you want to combine.
An empty destination cell if you want to join cell contents with a formula. Keeping the source cells unchanged is usually the safest option.
A backup or a copy of the workbook if you plan to merge cells that may contain data.

You do not need an add-in for either method. The formulas below work in current desktop Excel, and the basic ampersand method also works in older Excel editions. Excel for Mac and Excel for the web have the same main formula options; some ribbon labels or layouts may look different.

Step-by-Step

Choose what “combine” means for your task. If you need the values from two or more cells together—for example, a first name and last name in one cell—use a formula. This creates a combined result in a separate cell and leaves the original cells intact. If you only want one larger area for a heading or layout, use Merge Cells. Merging is a formatting change, not a way to preserve all the selected values.
Choose an empty destination cell for a formula. For example, if the source data is in A2 and B2, click C2, or another blank cell where the result can fit. Check that the destination cell is not inside the source range. A formula entered into one of its own source cells can overwrite data or produce a circular reference.
Join two cells with the ampersand operator. With the first name in A2 and the last name in B2, type the formula below into C2 and press Enter. In this example, A2 contains “Maya” and B2 contains “Chen,” so the result is “MayaChen.” The ampersand joins the values exactly as they are; it does not add punctuation or spacing by itself.
With names in A2 and B2, where A2 is Maya and B2 is Chen, enter: =A2&B2. The result in C2 is MayaChen.
Add a separator when the combined values need one. To put a space between the same names, replace the previous formula with the version below. The text between the quotation marks is a literal space. You can use a hyphen, comma, slash, or other separator in the same way; include any needed spaces inside the quotation marks.
With Maya in A2 and Chen in B2, enter: =A2&" "&B2. The result is Maya Chen.
Combine more than two cells with TEXTJOIN. TEXTJOIN is useful when you want one separator between every item in a range. Its second argument tells Excel whether to ignore empty cells. With item names in A2:C2—“Red,” “Blue,” and “Green”—enter the formula in D2. The result is “Red, Blue, Green.” TEXTJOIN is available in Microsoft 365 and supported newer Excel versions; if your Excel version does not recognize it, join cells with ampersands instead.
With Red in A2, Blue in B2, and Green in C2, enter: =TEXTJOIN(", ",TRUE,A2:C2). The result in D2 is Red, Blue, Green.
Copy a formula down a list if needed. If each row has a first name in column A and a last name in column B, put the formula in the first destination row, such as C2. Select C2 and drag its fill handle—the small square at the lower-right corner of the cell—down the rows you need. Excel adjusts the references for each row, so the formula in C3 uses A3 and B3. Double-clicking the fill handle can fill down alongside an adjacent, continuous data range. Check the last few results to confirm the references followed the rows correctly.
Keep only the combined results, if that is your goal. Formula results update when their source cells change. To replace the formulas with fixed text, select the result cells and press Ctrl+C on Windows, then right-click the selection and choose Paste Special > Values. This pastes the displayed results over the formulas. On Mac, copy with Command+C and use the Paste Special or paste-values option available in the context menu or Home tab. Paste values only after checking that the results are correct; once replaced, the cells no longer update from their sources.
Merge cells only when you want a single larger cell. Select adjacent cells that form a rectangle, such as A1:C1. On the Home tab, open the dropdown beside Merge & Center and choose Merge Cells if you want to keep the text aligned as it is, or Merge & Center if centered text is appropriate. In current Excel for Windows, the command is on Home > Merge & Center. On Mac or Excel for the web, select the cells and look for the merge options on the Home tab; the exact placement can vary with the window size. If the selected cells contain several entries, Excel warns that only the upper-left value will be kept. Cancel if you need to preserve the other values.

Common Mistakes

Assuming Merge Cells joins text. Merge Cells combines the selected cell areas, not their contents. If A1 contains “North” and B1 contains “Office,” merging them does not produce “North Office.” The value in the upper-left cell is retained, and the other value is discarded after you confirm the warning. Use a formula to join text instead.

Leaving out a separator. The formula =A2&B2 will put the values directly next to each other. That is correct for some codes, but names and address parts usually need a space or punctuation. Put the separator in quotation marks between the cell references, and check for accidental double spaces in the source values.

Overwriting the source data. Entering a formula into A2 when the formula also refers to A2 can replace the original value or create a circular reference. Use a separate, empty output column until you have verified the combined results.

Expecting formulas to preserve formatting. A formula combines cell values, not their individual fonts, colors, or number formats. For instance, joining a date cell to text can show a serial number if Excel treats the date as a number. If the output needs a specific date appearance, format or convert the date deliberately before joining it, and inspect the result.

Merging cells in a sortable data table. Merged cells can interfere with sorting, filtering, selecting ranges, and filling formulas. Avoid merging cells inside a structured list or table. For a heading across columns, consider centering the text across the selection without merging, where that alignment option is available, or place the heading in one cell.

Tips

Use a formula when the combined value needs to stay current. If a name changes in A2 or B2, a formula in C2 recalculates automatically. Use Paste Special > Values only when you specifically need a fixed result, such as preparing a file for an application that should not receive formulas.

Choose separators to match the data. A space suits names, a comma and space can suit city and region, and a line break may help combine address details within one cell. To insert a line break in a formula, you can use the CHAR function, but enable Wrap Text so the line break is visible. For most everyday combinations, a space or comma is easier to read and less likely to cause import issues.

TEXTJOIN can skip blanks when its second argument is TRUE, which helps avoid extra separators if some cells in the range are empty. If you use ampersands instead, blank cells still contribute no text, but the separators you typed remain. For example, a missing middle name can leave two spaces if the formula includes a space on each side. Check how empty cells affect your chosen pattern.

Keep the original columns until you have reviewed the output. Compare several results, including rows with blank cells, punctuation, long text, and non-English characters. If the combined results look right, you can decide whether to keep the source columns, hide them, or replace formulas with values. Keeping a copy makes it easier to correct a separator or recover data later.

Troubleshooting

The formula appears as text instead of calculating: Check that the cell is not formatted as Text. Change its number format to General, re-enter the formula, and press Enter. Also make sure the entry begins with an equals sign and that “Show Formulas” is not turned on. On Windows, Ctrl+` toggles formula display; on many Mac keyboards, the equivalent is Control+` (the key may require a different combination depending on the keyboard).

The result has no spaces or punctuation: Add the intended separator as text in quotation marks. For example, a formula joining names needs a quoted space between the references. If the result has too many spaces, inspect the original cells for leading or trailing spaces and remove them or clean the source data.

Excel reports a problem with TEXTJOIN: Confirm that the function name is spelled correctly and that your Excel version supports it. The formula uses commas between arguments in the English-language settings shown here. If your regional settings use semicolons as argument separators, Excel may require semicolons instead. You can use the ampersand method if TEXTJOIN is unavailable.

A merged cell contains only one of the original entries: That is expected behavior. Use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if you just merged and want to restore the cells. If you have made other changes since then, restore the missing values from a backup, version history, or the original data. A formula cannot recover content that was discarded by merging.

The formula results do not update: Check that Excel calculation is set to Automatic under Formulas > Calculation Options > Automatic. Also verify that the result cell contains a formula rather than a pasted value. If you intentionally used Paste Special > Values, the result is fixed and will not change when the source cells change.

Frequently Asked Questions

Does merging cells combine their text?
No. Merging makes one larger cell and keeps the value from the upper-left cell. Use a formula such as an ampersand combination or TEXTJOIN to put multiple cell values together.

Can I combine cells without losing the original data?
Yes. Put a formula in an empty destination cell and leave the source cells alone. The formula displays a combined result while the original entries remain available to edit.

How do I combine cells and add a space between them?
Join the cell references with a quoted space between them, as in =A2&" "&B2. Replace the space inside the quotation marks with another separator if needed.

Can I combine cells from different rows or columns?
Yes. A formula can refer to cells in different places, such as A2 and D2, or join a range such as A2:C2. The source cells do not have to be adjacent, though the order of references determines the order of the output.

Can I undo a cell merge?
Use Undo right after merging—Ctrl+Z in Windows or Command+Z on Mac. You can also select the merged cell and use the merge dropdown to unmerge it, but unmerging does not restore values that were discarded from the other cells.

Should I use a formula or Merge & Center?
Use a formula when you want the cell contents combined into a readable value, such as a full name. Use Merge & Center for a visual heading or label spanning cells, and avoid it in data you need to sort or filter.

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.