100% Client-Side:XLSX, CSV, TSV, Markdown & JSON parsing runs locally in browser memory with zero server uploads.
SheetCombineSheetCombine
Zero Formulas Required • Instant 1-Click Execution

How to Combine Two Columns in Excel

Upload your file or paste your spreadsheet below. Click "Combine Columns" in the green action bar to merge First and Last Name, addresses, or SKUs with any custom delimiter.

Quick Answer — Combine Two Columns in Excel Without Losing Data:

Type =A2 & " " & B2 (or =TEXTJOIN(" ", TRUE, A2:B2) to skip blanks) in Column C, fill down, then Copy → Paste Values before deleting A or B — or run Combine Columns in 1 click below.Read full guide →

A1
fx
Zero Uploads
fx

Instant Excel Formula Generator

Need to copy a formula directly into desktop Excel? Configure your columns below to generate the exact formula:

Your Ready-to-Paste Formula:=A2 & " " & B2

Why Does Excel's "Merge & Center" Delete Data?

Many users make the mistake of selecting Column A and Column B and clicking Excel's native Merge & Center button. When you do this, Excel displays a warning: "Merging cells only keeps the upper-left value and discards other values." All data in your second column is permanently erased.

To combine data without losing values, you must either concatenate the columns or use our online tool above, which automatically creates a combined column while leaving your original data completely intact.

Common Column Combination Scenarios

First Name + Last Name

Combine "Sarah" (A2) and "Connor" (B2) with a space:

=A2 & " " & B2

Last Name, First Name

Formal directory format with a comma:

=B2 & ", " & A2

City, State ZIP

Merging address fields across 3 cells:

=A2 & ", " & B2 & " " & C2

SKU Prefix - Item Code

Joining product codes with a dash:

=A2 & "-" & B2