How to Combine Two Cells in Excel and Keep Both Values

How-to basics · Updated November 19, 2026

To combine two cells in Excel and keep both values, put a formula in a third cell, such as =A2&" "&B2 when the values are in A2 and B2. This joins the contents with a space while leaving the original cells unchanged; using Merge Cells instead can discard one cell’s contents.

The safest way to combine two cells

In Microsoft Excel for Microsoft 365 on Windows, select an empty cell where you want the combined result to appear, enter a joining formula, and press Enter. For example, if A2 contains Ada and B2 contains Lovelace, enter =A2&" "&B2 in C2. C2 displays Ada Lovelace. A2 and B2 still contain their original values.

The ampersand (&) joins text, and the quoted space inserts a separator between the two cell references. Change the text between the quotation marks to get a different result. For a hyphen with spaces around it, use =A2&" - "&B2. With the same example values, the result is Ada – Lovelace.

After entering the formula in the first row, copy it down if you have more records. Use the fill handle—the small square at the lower-right corner of the selected cell—or copy and paste the formula into the rows below. Excel adjusts the references for each row, so a formula in C3 refers to A3 and B3.

Choose a separator that suits the data

A separator makes the combined result readable. Names usually need a space; addresses may need commas; product codes might need a hyphen; and concatenated text may need no separator at all. Decide what the finished value should look like before filling the formula down a column.

  • For first and last names, use a space: =A2&" "&B2.
  • For city and state, use a comma and space: =A2&", "&B2.
  • For a code with no gap, use =A2&B2.
  • For a label and an ID separated by a colon, use =A2&": "&B2.

Each example assumes the first component is in A2 and the second is in B2. For instance, if A2 is Seattle and B2 is WA, the comma formula returns Seattle, WA. The formula adds only the separator you specify; it does not infer punctuation or check whether the pieces are in the right order.

If you are combining several cells and want to skip empty cells, TEXTJOIN can be more convenient than typing each reference separately. With the values to combine in A2:C2, enter =TEXTJOIN(" ",TRUE,A2:C2) in D2. If A2 is Ada, B2 is blank, and C2 is Lovelace, the result is Ada Lovelace rather than a result with an extra separator for the blank. TEXTJOIN is available in Microsoft 365 and newer Excel versions, including Excel 2019 and later.

What happens to numbers, dates, and formatting

When a formula joins values, Excel creates a text result. This matters when one of the cells contains a number, date, or currency amount. The displayed result may not retain the source cell’s number format. A date that appears as 3/14/2026 in its cell, for example, can appear as a serial number when joined directly, because Excel stores dates as numeric values.

To control how a number appears in the combined text, wrap its cell reference in TEXT. Suppose A2 contains the item name Cable and B2 contains the numeric price 12.5. With the item in A2 and price in B2, enter =A2&" - "&TEXT(B2,"$0.00") in C2. The result is Cable – $12.50. The TEXT pattern specifies two decimal places and a dollar sign; choose a pattern appropriate to your data and regional conventions.

For a date, suppose A2 contains an event name and B2 contains a real Excel date value. With those values in A2 and B2, enter =A2&" on "&TEXT(B2,"mmmm d, yyyy") in C2. If A2 is Meeting and B2 is March 14, 2026, the result is Meeting on March 14, 2026. The format text controls the date’s appearance in the result; it does not change the underlying date in B2.

If the value is an identifier such as 007, make sure Excel has not already converted it to the number 7. Once leading zeros have been removed by numeric conversion, joining the cell cannot restore them automatically. Store identifiers as text or apply a deliberate format before combining them.

Handle blanks and line breaks

A simple formula that includes a space can leave an unwanted leading or trailing space when one input is blank. For two cells that may be empty, a formula with a condition can avoid adding a separator unless both cells contain something. With the values in A2 and B2, enter =IF(A2="",B2,IF(B2="",A2,A2&" "&B2)) in C2. If A2 is blank and B2 is Lovelace, it returns Lovelace; if both contain text, it returns the two values separated by one space.

For a result on two lines within a single cell, use a line-break character. With the first value in A2 and the second in B2, enter =A2&CHAR(10)&B2 in C2, then select Home > Wrap Text. CHAR(10) inserts a line break in the cell. The row may need to be made taller, or AutoFit applied, before both lines are visible. The data is still one cell’s text, not two separate rows.

Keep the result after removing the formula

A joined formula updates if its source cells change. That is useful for a working list, but sometimes you need a fixed result for exporting, sharing, or deleting the original columns. Copy the formula results and paste them as values into a destination range.

  1. Select the cells containing the combined formulas and copy them with Ctrl+C on Windows.
  2. Select the destination cell or range, then use Home > Paste > Values. Depending on the ribbon layout, the Values option may be shown as a clipboard icon with 123.
  3. Check a few results before deleting or changing the source columns. The pasted values no longer recalculate when the originals change.

On a Mac, use Command+C to copy and choose Home > Paste > Values, or use the available Paste Special options. Excel for the web also offers paste-values options, though the ribbon layout can differ from the desktop app. If the formula itself is useful, keep it in a separate column and retain the source data instead of replacing either input.

Combining values is not the same as merging cells

Excel’s Merge & Center command changes the cell layout; it is not a method for joining two values. If two selected cells both contain data, merging them retains the upper-left cell’s content and removes the content in the other selected cells. Excel may display a warning before proceeding. Do not accept the merge if you need both original entries.

To find the merge command in Excel for Microsoft 365 on Windows, select the cells and use Home > Merge & Center. The drop-down includes other merge options. If you merged cells by mistake, use Ctrl+Z promptly to undo the action. On a Mac, Command+Z is the undo shortcut. Unmerging later restores the cell layout, but it does not bring back content that was discarded during the merge.

A formula is generally the right choice when you need a combined text value and want both source cells kept. Merging is for making a larger visual cell—often for a heading across columns—not for joining records. If the goal is simply to center a heading across a range without merging cells, Center Across Selection is another formatting approach available in the Format Cells alignment options.

Common problems and how to fix them

  • The formula appears as text: Check that the cell is not formatted as Text, and that the entry begins with an equals sign. Change the format to General, then re-enter the formula.
  • The combined date looks like a number: Use TEXT around the date reference and specify the required date pattern.
  • There is no space between words: Include a quoted space between the cell references, such as =A2&" "&B2.
  • There is an extra separator: Check for blank source cells. Use TEXTJOIN with its ignore-empty argument set to TRUE, or use a conditional formula for two inputs.
  • The result changes unexpectedly: The formula refers to source cells, so edits to those cells update the result. Paste as values if you need a snapshot.
  • Only one value remains after a merge: Undo immediately if possible. A merged cell is not a safe way to preserve multiple entries.

When a formula is copied down, also check whether the source references point to the intended columns. Relative references such as A2 and B2 shift by row when filled downward. If a reference should always point to one fixed cell, it may need dollar signs, as in $A$2; that is a separate reference choice from joining the values.

Frequently Asked Questions

Can I combine two Excel cells without losing data?
Yes. Put a joining formula in a third cell, such as =A2&" "&B2. The formula creates a combined result and leaves A2 and B2 intact. Avoid Merge Cells when both original values matter.

Can I combine cells and keep the result as plain text?
Yes. Copy the formula result and use Paste Values in the destination. This keeps the displayed combined text but removes the link to the source cells, so later edits to those cells will not update the pasted result.

How do I combine cells but skip blanks?
For multiple cells in A2:C2, use =TEXTJOIN(" ",TRUE,A2:C2). TEXTJOIN uses a space as the separator and TRUE tells Excel to ignore empty cells. For exactly two cells, a conditional formula can also prevent an unnecessary separator.

Does Merge & Center combine the contents?
No. It combines the selected cell area visually, not the values. When multiple selected cells contain data, Excel keeps the upper-left value and can discard the others. Join the values with a formula first if you need them together.

Can I combine cells into separate lines?
Yes. Join the cell references with CHAR(10), then turn on Home > Wrap Text. The result displays on multiple lines inside one cell, though the row may need extra height to show all of it.

Will the combined formula keep currency or date formatting?
Not necessarily. A formula result is text, and source formatting may not carry through. Use TEXT with an explicit number or date pattern when the combined result must show a particular format.

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.