How to Merge Two Text Cells in Excel: Methods, Formulas, and What to Know First

Combining text from two cells in Excel sounds simple — and often it is. But depending on what you're trying to build, there are several ways to do it, each with trade-offs worth understanding before you commit to one approach.

What "Merging" Text Cells Actually Means

There's an important distinction to make upfront: merging cells and combining text from cells are two different things in Excel.

• Merge & Center (the button on the Home tab) physically joins two or more cells into one, keeping only the content from the upper-left cell and discarding everything else. This is a formatting feature, not a data-combination tool.
• Combining text values means pulling the content from two cells and displaying the result together — either in a third cell or as part of a formula. This is what most people actually need.

This article focuses on the second meaning: joining the text content of two cells into a single output.

Method 1: The Ampersand Operator (&)

The ampersand is the most widely used and easiest-to-read method for concatenating (joining) text in Excel.

Basic syntax:

This joins whatever text is in A1 directly with whatever is in B1 — no space between them.

Adding a space between values:

You insert a space (or any character) as a text string between the two cell references.

Example: If A1 contains "John" and B1 contains "Smith", then =A1&" "&B1 returns John Smith.

You can also add other characters, like a comma or dash:

Returns: Smith, John

The ampersand method is clean, fast, and works in every version of Excel.

Method 2: The CONCATENATE Function

CONCATENATE was the original text-joining function in Excel and works the same way as the ampersand operator.

This is functionally identical to =A1&" "&B1. Microsoft has largely replaced it with CONCAT and TEXTJOIN in newer versions, but CONCATENATE still works in all current versions for backward compatibility.

If you're working in a shared environment where colleagues use older Excel versions, CONCATENATE is safe to use.

Method 3: CONCAT (Newer Versions)

Introduced in Excel 2019 and available in Microsoft 365, CONCAT is a cleaner replacement for CONCATENATE. It accepts ranges, not just individual cells, which makes it useful when joining more than two cells.

For two cells, the difference from CONCATENATE is minimal. The advantage shows when you're combining longer lists.

Method 4: TEXTJOIN (Most Flexible for Multiple Cells)

TEXTJOIN is the most powerful option when you're working with more than two cells, but it's worth knowing for two-cell scenarios as well because of its built-in separator control.

• The first argument is the delimiter (separator between values)
• The second argument (TRUE) tells Excel to ignore empty cells
• The remaining arguments are the cells to join

If either cell is blank, TEXTJOIN skips it cleanly — no double spaces or dangling commas. That makes it more resilient than the ampersand method when your data isn't perfectly filled in.

TEXTJOIN is available in Excel 2019 and Microsoft 365. It's not available in Excel 2016 or earlier.

📋 Quick Comparison of Methods

Handling Numbers and Dates in Text Joins

If one of your cells contains a number or date, Excel may not format it the way you expect when concatenating.

A date stored as a serial number (which is how Excel stores dates internally) will appear as a raw number if you just use &. To display it correctly, wrap it in TEXT:

The same applies to numbers where you want specific decimal places or currency formatting:

This is a common source of confusion when people merge cells containing mixed data types.

What Happens to the Original Cells

When you use any formula-based method, the original cells stay intact — you're just reading their values and displaying a combined result in a new cell. Nothing is deleted.

If you want the combined text to be a permanent value (not a formula that updates when source cells change), you can:

1. Copy the formula cell
2. Paste Special → Values only

This replaces the formula with the static text result.

🔍 Where Your Setup Changes the Answer

The right method depends on factors specific to your situation: which version of Excel you're running, whether your data includes blanks or mixed types, whether the result needs to stay dynamic or become a fixed value, and how complex your overall spreadsheet is. A simple name-combination task in a personal spreadsheet calls for something different than a data-cleaning workflow processing thousands of rows with inconsistent entries. Understanding which variables are in play in your own file is what determines which method actually fits.