Combine Two Cells in Excel and Keep Both Text

How-to basics · Updated November 19, 2026

To combine text from two cells and keep both entries, join them with a formula such as =A2&" "&B2; replace the space inside the quotation marks with the separator you want. Do not use Home > Merge & Center to combine their contents: Excel’s merge command keeps only the upper-left cell’s value and discards the other cell’s value.

Combining text is different from merging cells

In Excel, “combine cells” can mean two different things. Joining text creates a new text value from the contents of multiple cells. Merging cells changes the worksheet layout so that two or more neighboring cells become one larger cell. These operations are not interchangeable.

A formula is usually the right choice when you want both pieces of text to appear together—for example, a first name and last name, a street and apartment number, or a product code and description. The original entries stay in their own cells, and the formula displays the combined result elsewhere. A merged cell, by contrast, is mainly a layout feature, such as a heading centered over several columns. It does not join the contents.

This distinction matters because a worksheet may look as though its text has been combined after a merge, even though one value has actually been removed. If you need to preserve every entry, make a combined formula result first, then decide whether you also need a layout change.

Join two cells with the ampersand formula

The ampersand (&) is a simple, widely supported way to join cell contents. It joins the values on either side of it, and you can include quoted text between the cell references to add a separator.

  • With a first name in A2 and a last name in B2, the formula below returns Maya Chen.
  • With a city in A2 and a state abbreviation in B2, replace the space with a comma and a space to return a result such as Portland, OR.
  • For a hyphenated identifier, put "-" between the references instead of a space.

With Maya in A2 and Chen in B2, enter this formula in an empty cell such as C2: =A2&" "&B2. The formula returns Maya Chen.

The formula does not alter A2 or B2. If either source cell changes, the result updates automatically. Keep the result in a separate column while you still need the original entries; typing over a source cell can break a formula that refers to it.

Use CONCAT or TEXTJOIN instead

Excel also provides functions for joining text. CONCAT combines text from references or ranges, while TEXTJOIN adds a chosen delimiter between items and can ignore empty cells. Both are available in Microsoft 365 for Windows. For only two cells, the ampersand is often the quickest option, but functions can be easier to read in longer formulas.

With Maya in A2 and Chen in B2, enter this in C2: =CONCAT(A2," ",B2). The result is Maya Chen. CONCAT does not add spaces or punctuation automatically; the quoted space is an argument that supplies the separator.

With Maya in A2, B2 blank, and Chen in C2, enter this in D2: =TEXTJOIN(" ",TRUE,A2:C2). The result is Maya Chen. The first argument sets the separator, and TRUE tells TEXTJOIN to ignore empty cells. Change TRUE to FALSE if you want empty cells to count as empty positions between separators.

Older workbooks may use CONCATENATE, an older text-joining function. It can still be encountered in existing spreadsheets, but for a new formula, the ampersand, CONCAT, or TEXTJOIN is generally more convenient. CONCAT and TEXTJOIN do not require a special keyboard shortcut: enter the formula in a cell and press Enter.

Choose a separator and handle blank cells

Decide how the combined text should read before copying a formula down a column. A space is suitable for names, a comma-space for city and region, and a slash or hyphen for some codes. Excel treats the separator you type in quotation marks as literal text, so punctuation and spaces appear exactly as entered.

If you use the ampersand with a blank cell, Excel still includes any literal separator in the formula. For example, if B2 is empty, =A2&" "&B2 leaves a trailing space after A2’s text. That may not be visible in the cell, but it can matter when the result is used elsewhere. TEXTJOIN with its ignore-empty option is often a better fit for a range in which some cells may be blank.

For two cells where the second one may be blank, an IF formula can omit the separator when needed. With A2 containing a name and B2 optionally containing a middle name, enter this in C2: =A2&IF(B2<>""," "&B2,""). If A2 contains Maya and B2 is blank, the result is Maya; if B2 contains Lee, the result is Maya Lee. This example assumes A2 is always populated.

Preserve dates, numbers, and displayed formatting

When a formula joins a date or number to text, Excel may show the underlying stored value rather than the format you see in the source cell. Dates are stored as serial numbers, and number formatting is usually a display instruction, not part of the cell’s underlying value. If a combined result shows an unexpected number, use the TEXT function to specify how that value should appear.

With the label Due in A2 and a real Excel date of November 3, 2026 in B2, enter this in C2: =A2&": "&TEXT(B2,"mmmm d, yyyy"). The result is Due: November 3, 2026. The format code inside TEXT controls the date display; it does not change the date stored in B2.

With an item name in A2 and a numeric price of 1250 in B2, enter this in C2: =A2&" - "&TEXT(B2,"$#,##0.00"). If A2 contains Notebook, the result is Notebook – $1,250.00. Choose a format that suits your data, and remember that symbols and decimal places in the result are text once joined.

Copy the result down and make it permanent

To combine matching rows, enter the formula in the first result row and fill it down. In Excel for Microsoft 365 on Windows, select the formula cell and drag its fill handle—the small square at the lower-right corner—down the column. Excel adjusts relative references, so a formula using A2 and B2 becomes one using A3 and B3 on the next row. Check a few results, especially where source cells are blank or formatted differently.

Formulas remain linked to their source cells. If you need a fixed text result that will not change when the source data changes, copy the formula results and paste values over them or into another column. In Microsoft 365 for Windows, use Home > Copy, then Home > Paste > Paste Values. On Mac, the Paste Values command is also available from the Home tab; exact ribbon presentation can vary with the Excel version. Keep a copy of the formula results or original data until you have confirmed the pasted output.

Pasting values replaces formulas with their current displayed values. It is useful before sharing a file with a system that expects plain text or before removing the original columns. It is not the same as merging cells, and it does not preserve a live connection to the source cells.

Why Merge Cells can lose information

To merge cells for layout in Excel for Microsoft 365 on Windows, select adjacent cells and choose Home > Merge & Center in the Alignment group. Use the button’s drop-down for other merge options, such as Merge Cells or Merge Across. If the selected cells contain multiple entries, Excel warns that merging keeps only the upper-left cell’s content and discards the other values. Cancel the operation if you need to retain those entries.

If you want both text values and a wide, centered heading, first join the text with a formula and confirm the result. Then, if a merged layout is genuinely needed, place the final text in the upper-left cell of the intended range before merging. Merged cells can make sorting, filtering, selecting ranges, and editing a table less convenient, so they are best used sparingly in data tables.

For a heading that should span columns without merging, consider selecting the range and using the horizontal alignment option Center Across Selection in the Format Cells dialog. This changes how text is displayed without combining the cells, though it is a formatting choice rather than a way to join their contents.

Common problems and quick fixes

  • The result has no space: Cell references join directly unless you add a quoted separator, such as " ".
  • A date looks like a number: Wrap the date reference in TEXT and provide a date format, as in the example above.
  • The formula appears as text: Check that the cell is not formatted as Text. Change it to General, then re-enter the formula; changing the format alone may not recalculate text already entered as a formula string.
  • Excel shows a formula error: Check that the cell references are correct and that quotation marks and parentheses are paired. In some regional settings, Excel uses semicolons instead of commas as formula argument separators; the examples here use commas.
  • The original text disappeared after a merge: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the operation is still undoable. If the workbook has since been saved or edited, restore from a version or backup if available; a merge does not create a joined-text formula.

Frequently Asked Questions

Can I combine two cells without losing the original text?
Yes. Use a formula in a third cell, such as =A2&" "&B2. The source cells remain unchanged. Avoid merging the two source cells if both contain data.

Can I combine cells and remove the original columns?
Yes, after checking the combined results. Copy the result column and use Home > Paste > Paste Values, then confirm the fixed text is correct before deleting source columns. Consider keeping a backup if the original entries may be needed later.

How do I join cells but skip blanks?
Use TEXTJOIN with TRUE as its ignore-empty argument. For the range A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins nonblank entries with spaces and omits blank cells.

Does Merge & Center combine the text from both cells?
No. It combines the selected cells’ layout area, not their text. If more than one selected cell contains data, Excel keeps the upper-left cell’s value and discards the other contents.

Can I join text from two cells on Mac or in Excel for the web?
Yes. The ampersand, CONCAT, and TEXTJOIN formulas work in current Excel versions on Mac and Excel for the web. Ribbon placement and keyboard shortcuts can differ, but the formula logic is the same.

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.