How do I combine two columns in Excel without losing data?

Don't use Merge & Center — it deletes all but the top-left cell. Instead join the values in a new column with =TEXTJOIN(" ", TRUE, A2, B2) or =A2&" "&B2, then paste as values. Tellsheet's Merge Cells does this in place with a separator of your choice and no data loss.

What's the difference between Merge & Center and combining data?

Merge & Center is a formatting feature that spans one value across several cells and discards the others. Combining data joins the text from several cells into one — that's what TEXTJOIN, CONCAT, or Tellsheet's Merge Cells do.

How do I combine first and last name into one column?

Use =A2&" "&B2 or =TEXTJOIN(" ", TRUE, A2, B2), then paste as values. Or select both columns and run Tellsheet's Merge Cells with a space separator — the reverse of the Split Names tool.

Home › Excel Guides › Combine Columns in Excel

How to Combine Columns in Excel Without Losing Data

The trap: Excel's Merge & Center keeps only the top-left cell and throws the rest away. Here's how to actually join columns into one — with a formula, or in one click.

Last updated: August 2026

First	Last		Combined
Ada	Lovelace	→	Ada Lovelace
Grace	Hopper	→	Grace Hopper

Why not Merge & Center?

Merge & Center is a formatting tool — it spans a single value across several cells for a title row. Point it at two columns of data and Excel warns it will keep only the upper-left value. That's data loss, not combining.

Method 1 — TEXTJOIN or the & operator

In a new column: =TEXTJOIN(" ", TRUE, A2, B2, C2) — joins with a space and skips blanks (no doubled separators).
Or the classic: =A2&" "&B2 for two columns.
Copy the new column, then Paste Special > Values so it survives when you delete the originals.

TEXTJOIN needs Excel 2019 or Microsoft 365. On older versions use CONCATENATE or the & operator.

The 1-click way — Tellsheet

Merge Cells joins the selected columns into one with a separator you choose (space, comma, “ - ”), skips blank cells so you never get doubled separators, and writes the result in place — the other columns are emptied but kept, so nothing to the right shifts. No formulas, no paste-special. It's the reverse of Split Names and Split Text, and every change previews before it's applied.

Frequently asked questions

How do I combine two columns without losing data?

Don't use Merge & Center. Join in a new column with =TEXTJOIN(" ", TRUE, A2, B2) and paste as values, or use Tellsheet's Merge Cells to join in place with no data loss.

What does Merge & Center actually do?

It's formatting: it spans one value across cells and deletes the others. It doesn't combine text.

How do I combine first and last name?

=A2&" "&B2, or select both columns and run Merge Cells with a space separator.

Can I add a separator between the values?

Yes — TEXTJOIN's first argument is the separator, and Merge Cells lets you type any separator (a space, “, ”, “ - ”, etc.).

Related Excel guides

Combine columns in one click

Merge Cells joins columns with your separator and no data lost — right inside Excel, with a preview first.

Get Tellsheet free See pricing