How to Combine Two Cells in Excel Without Losing Data

Combining the contents of two or more cells is a fundamental task in Excel, but it comes with a common pitfall: accidentally deleting your data. If you’ve ever used the “Merge & Center” button only to see your information vanish, you’re not alone. This guide will walk you through several easy and data-safe methods to combine cells correctly, from simple formulas to more powerful functions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, The One Method to Avoid: Merge & Center

The "Merge & Center" button on the Home tab seems like the obvious solution, but it’s designed for formatting, not for combining data. It physically merges a group of cells into one larger cell and is great for creating titles that span multiple columns.

However, it has one major drawback: it only keeps the data from the top-left cell and deletes everything else permanently. When you try to use it on cells that all contain data, Excel will even pop up a warning:

“Merging cells only keeps the upper-left value and discards other values.”

Unless your goal is purely cosmetic and you're okay with losing data, you should avoid Merge & Center for combining text or values. Let’s look at the correct ways to do it.

Method 1: The Ampersand (&) Operator

The quickest and most common way to combine cell data is by using the ampersand symbol (&). This symbol acts as a “join” operator, telling Excel to take the content from one cell and append the content from another.

Let's say you have a list of first names in column A and last names in column B, and you want to create a full name in column C.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions:

1. Click on the cell where you want the combined result to go (in our example, C2).
2. Type the equals sign (=) to start your formula.
3. Click on the first cell you want to combine (A2).
4. Type an ampersand (&).
5. Now, if we just selected B2, the result would be "JohnSmith" with no space. To add a space, we need to manually insert it. Type a double quote, a space, and another double quote (" "). This tells Excel to treat the space as a piece of text.
6. Type another ampersand (&) to join the space to the next piece of data.
7. Click on the second cell you want to combine (B2).

Your final formula will look like this:

=A2&" "&B2

Press Enter, and you’ll see "John Smith" in cell C2. To apply this to your entire list, click on cell C2, grab the small square in the bottom-right corner (the fill handle), and drag it down. Excel will automatically adjust the formula for each row.

Method 2: Use the CONCATENATE Function

If you prefer using functions, Excel's longstanding CONCATENATE function does the same thing as the ampersand. It takes a list of items and joins them together. While it has been replaced by the newer CONCAT function in recent versions of Excel, it's still available for backward compatibility and works perfectly well.

The syntax is: CONCATENATE(text1, [text2], ...)

Step-by-Step Instructions:

1. Select the result cell (C2).
2. Type =CONCATENATE( to begin the function.
3. Select the first cell (A2).
4. Type a comma (,) to move to the next item you want to join.
5. Just like with the Ampersand method, we need to add a space. Type " " as the second argument.
6. Type another comma (, ).
7. Select the second cell (B2).
8. Close the parentheses ()).

Your final formula will look like this:

=CONCATENATE(A2, " ", B2)

This produces the exact same result as the ampersand method. The choice between them often comes down to personal preference. Some find the ampersand faster for simple joins, while others find the function more readable.

Method 3: The Modern CONCAT and TEXTJOIN Functions

Newer versions of Excel (Excel 2019, Microsoft 365) introduced two powerful new functions for joining text: CONCAT and TEXTJOIN. These offer more flexibility, especially when you're working with many cells.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The CONCAT Function

CONCAT is the direct replacement for CONCATENATE. The main difference is that CONCAT can accept a range of cells as an argument, whereas CONCATENATE only accepts individual cells.

The catch? CONCAT does NOT add delimiters (like spaces or commas) between the cells in the range. It just smashes them all together.

So, a formula like =CONCAT(A2:C2) containing "John" "Michael" "Smith" would return "JohnMichaelSmith". You would still need to add spaces manually, like this =CONCAT(A2," ",B2," ",C2). For this reason, CONCAT is most useful for situations where you don't need a separator.

The TEXTJOIN Function (The Most Powerful Option)

TEXTJOIN is the real star. This function lets you specify a separator (a "delimiter") one time and apply it between every cell in a range. You can also tell it to ignore any empty cells, which is incredibly useful for preventing extra spaces or commas in your final text.

The syntax is: TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Let's imagine you have a third column for a middle initial (column B), but some people don't have one.

Step-by-Step Instructions:

1. Select the desired cell (D2).
2. Type =TEXTJOIN( to start.
3. The first argument is the delimiter. We want a space, so type " ". Add a comma.
4. The second argument is whether to ignore empty cells. We absolutely do, otherwise we’ll get a double space for Jane Doe. Type TRUE. Add a comma.
5. The final argument is the text or range to join. Select the entire range of cells, from A2 to C2 (A2:C2).
6. Close the parentheses ()).

The finished formula is magically simple:

=TEXTJOIN(" ", TRUE, A2:C2)

Look at the result. It correctly assembled "John F. Smith" and, thanks to the TRUE argument, it correctly assembled "Jane Doe" without an extra space in the middle. This is the cleanest and most efficient method for combining complex ranges of text.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Important Final Step: Convert Formulas to Values

All of the methods above create a formula. This means the combined text is dynamically linked to the original cells. If you change a first name in column A, the full name in column D will update automatically.

But what if you're done and want to delete the original columns (A, B, and C)? If you do, your formulas will break and you'll get a #REF! error because the cells they were referencing are gone.

To make your combined data permanent and independent, you need to copy and paste it as values.

How to Paste as Values

1. Select all the cells containing your new formulas (e.g., the full names in column D).
2. Copy the cells by pressing Ctrl+C (or Command+C on Mac).
3. Right-click on the same selected area.
4. In the menu that appears, look for "Paste Options." Hover over them until you find the icon for Values (it usually looks like a clipboard with "123" on it). Click it.

Your cells will look the same, but if you click on one, you'll see the formula bar now contains the actual text ("John F. Smith") instead of the formula. The link is broken, and you can now safely delete the original columns without losing your work.

Final Thoughts

Combining cell data in Excel is effortless when you use the right tools. While "Merge & Center" is for visual layouts, the ampersand (&), CONCATENATE, and TEXTJOIN functions give you the power to combine data flexibly and without risk. Remember the crucial final step of pasting as values to lock in your work if you plan on removing the source data.

This kind of data cleanup and preparation in spreadsheets is a necessary but often time-consuming part of analysis and reporting. At Graphed, we help you skip these manual steps. By securely connecting directly to your sources - like Google Sheets, Excel files, or platforms like Google Analytics and Salesforce - we let you build real-time dashboards and reports just by describing what you need in plain English. No more wrestling with cell formatting or formulas, just instant answers. If you’re ready to turn hours of data prep into seconds, give Graphed a try.