Merge Content of Two Cells in Excel: Keep Both Values

How-to basics · Updated November 18, 2026

To combine the contents of two cells in Excel without discarding either value, enter a formula in a third, empty cell. For example, if the values are in A2 and B2, type =A2&" "&B2 in C2 to join them with a space. This creates a combined result while leaving the original cells unchanged. It is different from Excel’s Merge Cells command, which joins cells visually and can discard content.

Before you start, decide what should appear between the two values, such as a space, comma, or hyphen. You can keep the result as a formula so it updates when the source cells change, or copy it and paste it as a value if you need a fixed result.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same joining formula works in Excel for Mac and Excel for the web.
  • The two cells whose contents you want to combine, plus an empty cell for the result. Using a separate destination protects the original data while you check the output.
  • A clear idea of the separator you want between the values. A space is common for names, while a comma or hyphen may be better for other data.

Step-by-Step

  1. Check the source cells and choose the order. Identify which cell contains the first part and which contains the second. For example, if A2 contains Maya and B2 contains Chen, joining A2 before B2 gives a first-name-then-last-name result. If your columns are reversed, use them in the order you want the final text to appear. Combining cell contents does not rearrange the source cells.

  2. Choose a blank destination cell. Click an empty cell where you want the combined result, such as C2. Do not put the formula over A2 or B2: Excel needs those cells to remain available as inputs. If C2 already contains something you need, choose another empty cell or insert a new column first. A separate destination also makes it easier to compare the result with the originals.

  3. Enter the join formula. With the example layout of Maya in A2, Chen in B2, and the output in C2, enter =A2&" "&B2 in C2 and press Enter. The ampersand joins text, and the quoted space supplies a separator. The resulting display is Maya Chen. If you want the values joined with no space, remove the quoted space and its surrounding ampersands. Keep the equal sign at the start so Excel recognizes the entry as a formula.

  4. Check the result and the source values. Confirm that the combined text is in the intended order and that its separator looks right. A formula result is calculated from the source cells; it does not erase or move their contents. Click the result cell and look at the formula bar if you want to confirm which references it uses. If the result is wrong, edit the formula rather than typing over the source cells.

  5. Use the same formula for more rows if needed. If the same two columns contain additional pairs, select the formula cell and drag the small fill handle at its lower-right corner down through the needed rows. Excel adjusts relative references as the formula fills: the next row will refer to A3 and B3, then A4 and B4. Check the last few results, especially if your data has blank rows or a different layout partway down.

  6. Choose whether the result should keep updating. Leave the formula in place if you want the joined text to change when either source cell changes. If you need a fixed text result, copy the formula cell, then use Home > Paste > Values to replace the formula with its current displayed value. In Excel for Mac, use the Paste Values option in the Home tab’s Paste menu; labels and menu layout can vary slightly by release. On Windows, Ctrl+C copies and Ctrl+V pastes; on Mac, use Command+C and Command+V.

  7. Remove the original cells only after checking a fixed result. If your goal is to keep only the combined text, first paste the result as a value in a safe location and verify it. Then you can delete or clear the original cells if appropriate. Do not delete source cells while the output is still a formula that refers to them: the result may turn into a reference error. If you need an actual merged cell for a layout, see the distinction in the Tips section before using Merge Cells.

Common Mistakes

Using Merge Cells to combine the text. The Merge & Center or Merge Cells command changes the cell layout; it does not concatenate two values. When you merge cells that both contain data, Excel keeps the value from the upper-left cell and can warn that the other contents will be lost. To preserve both values, join them with a formula first. Only use the merge command when you specifically want one larger display area and have already protected any data you need.

Leaving out a separator. Joining two text values directly can make them run together. For example, Maya and Chen become MayaChen without a space. Add the separator inside quotation marks in the formula, or deliberately choose no separator when the pieces already contain punctuation or spacing.

Putting the formula in a source cell. A formula that refers to the cell it occupies can create a circular reference, and replacing a source value can destroy information you meant to preserve. Use a separate empty destination cell. If you need the combined text in a particular column, create it elsewhere first, verify it, and then move or paste the result as a value.

Deleting the inputs too soon. A formula is a live link to its input cells, not a detached copy of their text. Deleting or clearing those inputs can break the result. Convert the output to a value before removing the source cells, and keep a backup if the original data may be needed later.

Assuming blanks behave like spaces. If one source cell is empty, the formula still includes the separator you specified. That can leave an extra space at the start or end. Check the output when blanks are possible, or use a method that handles optional values when the dataset requires it.

Tips

Pick a separator that suits the data and the way people will read it. A single space works well for names, a comma followed by a space can suit city-and-region text, and a hyphen can make an identifier easier to scan. The separator is ordinary text inside quotation marks, so punctuation can be included there too. If the source values already contain spaces or punctuation, inspect a few examples before adding another separator.

Keep the original columns until you have checked the combined output. This gives you a simple way to spot reversed order, missing characters, or unexpected blanks. For a long list, check the first result, several results in the middle, and the last filled row. If the formula was copied down, make sure each row refers to the matching pair rather than a fixed or shifted range.

Remember that a formula result can look like ordinary text while still depending on its source cells. If you are preparing a file to send to someone who does not need the formula, paste values into the final location and confirm the displayed text remains. If the workbook is a working document, retaining formulas may be more useful because updates to the source cells flow through automatically.

For a quick one-off task, you can also type the desired combined text directly into a new cell. That can be convenient for just one pair, but it will not update if the original values change, and manual typing can introduce mistakes. A formula is usually the safer choice when the source cells are authoritative or when you have many rows.

Excel for the web can calculate the same joining formula. You can enter it in a blank cell just as you would in the desktop app. Some ribbon controls or paste options may be arranged differently in the browser, so use the available Paste Values command if you need to turn the formula result into fixed text.

Troubleshooting

The cell shows the formula instead of the combined result. Check whether the cell is formatted as Text, or whether an apostrophe was entered before the equal sign. Change the cell format to General, then edit the entry and press Enter again. Merely changing the format may not recalculate text that was already entered; re-entering the formula prompts Excel to evaluate it.

The result has no space or the wrong punctuation. Edit the formula in the destination cell and inspect the characters between the cell references. The separator must be inside straight double quotation marks. Remove or replace that text as needed, then press Enter. If a space appears at the beginning or end, check whether one of the source cells is blank or already contains extra spaces.

The output displays an error after you remove a source cell. The formula depends on the cells it references. Undo the deletion immediately if possible, or restore the source values from a backup. Then copy the output and paste values before clearing the inputs. If the source data cannot be recovered, recreate the combined text from another copy or record rather than expecting the broken formula to restore it.

The formula returns a result in the wrong order. Check the cell references in the formula bar. The order of references determines the order of the combined text, regardless of which columns appear visually closer together. Edit the formula so the first reference points to the first text you want and the second reference points to the next text.

The filled results repeat or skip values. Select a few output cells and compare their formulas. When filling down, relative references should change row by row. If the formula was copied from a different location or contains fixed references, correct the first formula and fill it down again. Also check that the source data does not have merged cells or gaps that make the row pairing differ from what you expect.

Frequently Asked Questions

Does merging two cells delete one of the values?
Excel’s Merge Cells feature does not combine the contents of both cells. If both contain data, Excel retains the upper-left cell’s value and may warn that other content will be lost. Use a joining formula first when you need both values.

Can I combine two cells without a space?
Yes. Join the two cell references directly, without putting a space between them. This is useful when the values already include their own separators or are parts of a code. Check the result carefully so the boundary between the two pieces remains understandable.

Can I use a comma or hyphen instead of a space?
Yes. Replace the space between the quotation marks in the formula with the separator you want, such as a comma and space or a hyphen. The separator is repeated between the values for every row where you fill the formula.

How do I combine two cells and keep only the finished text?
Put the formula in a separate cell, verify the result, then copy it and choose Home > Paste > Values. The pasted text no longer depends on the source cells. Keep or delete the originals only after confirming the fixed result is correct.

Will the combined result update when I edit either source cell?
Yes, if you leave it as a formula. Excel recalculates the result when a referenced cell changes. If you paste the result as a value, it becomes fixed and will not update when the original cells change.

Related

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.