How to Combine Two Columns in Excel Without Losing Data

First name in one column, surname in the next, and your email tool wants a single Full Name field. Or a product name and a colour that need to become one listing title. Joining two columns is one of the most common clean-up jobs I see in small business spreadsheets, and Excel gives you four ways to do it.

Before you reach for the Merge button, read the next section. It's the one mistake that can quietly delete half your list.

Why Merge Cells won't combine two Excel columns

It's natural to think Merge & Center on the Home tab would join two cells together. It doesn't join the text. Microsoft says that when you merge cells, only the upper-left cell's contents are kept, and the contents of the other cells are deleted.

So if you select a first name and a surname and merge them, you'll keep the first name and lose the surname. Merging is for making a big heading label stretch across columns, not for combining data. For combining, you want one of the methods below, which put the joined result in a new column and leave your originals alone.

Joining two Excel columns with the ampersand

This is the quickest route and the one I use most. Say first names are in column A and surnames in column B, starting in row 2.

1. Click the empty cell where you want the combined result, for example C2.
2. Type an equals sign, then click A2.
3. Type an ampersand, then a space inside quotation marks, then another ampersand.
4. Click B2 and press Enter.

The finished formula is =A2&" "&B2, which is the exact example Microsoft gives. Without the space in quotation marks you'd get the two words jammed together. Once the first row looks right, copy the formula down the rest of column C.

You can put anything inside those quotation marks. A comma and a space, a dash written as a word, or a label such as " Ltd" all work the same way.

Combining Excel columns with the CONCAT function

If you'd rather read a formula as words, CONCAT does the same job.

1. Click your result cell.
2. Type =CONCAT( and click the first cell.
3. Add a comma, then any separator in quotation marks, then another comma and the second cell.
4. Close the bracket and press Enter.

For two columns that gives you =CONCAT(A2," ",B2). Microsoft's own example, =CONCAT(A2, " Family"), shows how to tack a fixed word on the end, which is handy for things like mailing labels. Microsoft also notes that the older CONCATENATE function may not be available in future versions of Excel, so CONCAT is the safer one to learn.

Using TEXTJOIN when some Excel cells are blank

Empty cells are where the first two methods get messy. If a row has no middle name, you can end up with double spaces or a stray comma. TEXTJOIN fixes that.

Its layout, according to Microsoft, is TEXTJOIN(delimiter, ignore_empty, text1, and so on). The delimiter is the separator you want between items. Set ignore_empty to TRUE and Excel skips empty cells instead of adding an extra separator.

Microsoft's example is =TEXTJOIN(", ", TRUE, A2:B8), which joins everything in that range with a comma and space, skipping the gaps. It's brilliant for turning a column of tags or keywords into one comma-separated line for a listing or a blog post.

Two limits to know: Microsoft says you can supply up to 252 text arguments, and if the result goes over 32,767 characters, you'll get a #VALUE! error.

Combining two columns in Excel with Flash Fill

If formulas aren't your thing, Flash Fill spots a pattern and copies it for you.

1. In the first cell of your new column, type the combined version by hand, such as the full name, and press Enter.
2. Start typing the next one. Excel shows a grey preview of the rest of the column.
3. Press Enter to accept it.

If no preview appears, go to Data and select Flash Fill, or press Ctrl+E. Microsoft says the automatic preview is controlled by the Automatically Flash Fill box in the Advanced editing options. Because Flash Fill types the results in rather than writing a formula, I'd use a formula instead for any list that keeps growing.

Which way to combine Excel columns

Method	Best when	Handles blanks?
Ampersand	Two columns, quick job	No, you may get extra spaces
CONCAT	You like readable formulas	No
TEXTJOIN	Several cells, some empty	Yes, set ignore_empty to TRUE
Flash Fill	One-off tidy-up, no formulas	Follows your typed example

Combining columns in Excel for a customer or product list

For creators and small business owners, the usual reason to join columns is to get a list ready for another tool. A few habits help:

• Keep your original columns. Put the combined result in a new column so you can always rebuild it.
• Check the first few rows for double spaces, especially where a field is sometimes empty.
• Name the new column clearly, such as Full Name, so it maps cleanly when you import it elsewhere.

If part of your team works in Google instead, the same thinking applies there. My walkthrough of adding up numbers in Google Sheets covers the formula basics, and this guide to Google Sheets checkboxes is useful for ticking rows off once they're cleaned.

If your combined Excel column looks wrong

1. Seeing the formula as text rather than a result? Check the cell isn't formatted as Text, and that the formula starts with an equals sign.
2. Words jammed together? You've left out the space in quotation marks.
3. A #VALUE! error with TEXTJOIN? The result may be over the character limit Microsoft sets.
4. Lost data after merging? Undo straight away, then use a formula instead of Merge & Center.

Frequently asked questions

How do I combine two columns in Excel with a space?

Use =A2&" "&B2 in a new column, changing the cell references to match your data. The space inside the quotation marks goes between the two values.

Can I merge two columns in Excel without losing data?

Not with Merge & Center. Microsoft says merging keeps only the upper-left cell's contents. Use the ampersand, CONCAT, TEXTJOIN or Flash Fill instead.

What's the difference between CONCAT and TEXTJOIN?

CONCAT joins whatever you list. TEXTJOIN lets you set one separator for everything and skip blank cells when ignore_empty is TRUE.

Is CONCATENATE still worth using?

Microsoft says CONCATENATE may not be available in future versions of Excel, so CONCAT is the safer choice for new spreadsheets.

What shortcut runs Flash Fill?

Ctrl+E runs Flash Fill, or you can select Flash Fill on the Data tab.