How to Merge Two Columns in Excel (Without Losing Your Data)

Merging two columns in Excel sounds simple — until you realize Excel's built-in "Merge" button doesn't actually combine column content. It merges cells visually, keeping only the top-left value and discarding everything else. If you're trying to combine names, addresses, codes, or any two columns of data into one, you need a different approach entirely.

Here's what actually works — and why the right method depends on your situation.

What "Merging Columns" Really Means in Excel

There are two very different things people mean when they say merge columns:

• Visual merging — making two cells look like one (spanning headers, formatting). This is what Excel's Merge & Center button does.
• Content merging — combining the text or values from two columns into a single column. This is almost always what people actually want.

This article focuses on content merging, because that's where the real work happens.

Method 1: The Ampersand Formula (&)

The fastest way to combine two columns is using the & operator in a formula.

Example: You have first names in column A and last names in column B. In column C, you'd enter:

=A2&" "&B2 

This produces: John Smith

The " " adds a space between the values. You can swap that for a comma, dash, or any separator:

=A2&", "&B2 

Produces: Smith, John

Key point: This creates a formula, not plain text. If you need to delete columns A or B afterward, you'll first need to copy column C and paste it as values only (right-click → Paste Special → Values).

Method 2: The CONCAT or TEXTJOIN Function

For more control, especially with multiple columns or dynamic separators, Excel's built-in text functions are more flexible.

TEXTJOIN example:

=TEXTJOIN(" ", TRUE, A2, B2) 

The TRUE argument tells Excel to skip empty cells — useful when some rows have missing data and you don't want double spaces or stray commas.

Method 3: Flash Fill 🔦

If your data follows a consistent pattern, Flash Fill can merge columns without any formula at all.

1. Manually type the combined result for the first row in a new column
2. Start typing the second row
3. Excel will detect the pattern and suggest the rest — press Enter to accept

Flash Fill works well for straightforward combinations like full names or concatenated codes. It's not ideal for large datasets with inconsistent formatting or when you need the result to stay dynamic as source data changes.

The Variables That Change Everything

Which method works best isn't universal — it shifts based on several factors:

Your Excel version matters.TEXTJOIN and modern CONCAT aren't available in Excel 2016 or earlier. If you're on an older version, CONCATENATE or the & operator are your reliable fallbacks.

Whether you need the result to stay live. Formulas update automatically when source cells change. Flash Fill results are static — they won't update if the original data changes.

What happens to the original columns. If you need to delete columns A and B after merging, any formula referencing them will break. You'll need to convert formula results to plain values first.

Data cleanliness. Leading or trailing spaces in cells cause invisible problems in merged output. The TRIM function, wrapped around your references, catches this:

=TRIM(A2)&" "&TRIM(B2) 

Volume of data. For a few dozen rows, any method works fine. For thousands of rows with complex logic, formulas are more maintainable than manually typed Flash Fill results.

A Note on Number and Date Formatting

When you merge a column of text with a column of dates or numbers, Excel often outputs the raw serial number instead of the formatted value. A date that displays as 01/15/2024 might merge as 45306.

Fix this with the TEXT function:

=A2&" - "&TEXT(B2,"MM/DD/YYYY") 

This is one of the more common surprises people hit mid-project — the merge looks right in the formula bar but wrong in the cell.

Different Users, Different Right Answers 📋

A teacher combining student first and last names into a roster has different needs than a developer merging product codes and SKUs for an inventory export. Someone working in Excel 2013 on a shared company computer has different constraints than someone running Microsoft 365 on a personal machine with full admin access.

The mechanics of merging columns are straightforward once you know where Excel's built-in Merge button falls short. But whether you lean on a quick & formula, invest in TEXTJOIN for flexibility, or trust Flash Fill for speed — that depends on your data structure, how dynamic the result needs to be, and what version of Excel you're actually running. Your spreadsheet's specific shape is the piece no general guide can account for.