Tool 06

🔗 Merge Columns in Excel

Combines two or more columns into one new column with the separator you choose — without writing a single formula.

🔒 Works offline — your file never leaves your computer

What the column merger does

Before and after: merged columns

BeforeAfter
First Name: John | Last Name: SmithFull Name: John Smith
City: Boston | State: MA | ZIP: 02110Location: Boston, MA, 02110
⬇ Download Tool — Free
or use it right here in your browser →
Single HTML file · opens in Chrome, Edge, Firefox or Safari · no installation, no sign-up

How to merge columns in Excel in 3 steps

1
Download the toolClick the red button and save the file to your computer.
2
Open it in your web browserDouble-click the downloaded file. It opens in your browser — not in Excel. No installation, no account.
3
Choose your Excel file and save the cleaned copyClick "Run", check the before/after examples on screen, then save. Your original file stays untouched.

Before you start: limits and backup

Why merge columns without formulas

Mail merges, labels and many import templates expect a full name or a complete address in one single column, while your list keeps first name, last name, street and city in separate columns. In Excel that means writing a formula like =A2&" "&B2 and copying it down.

With this tool you simply click the columns in the order you want, choose a separator and give the new column a name. A preview shows the first row before anything happens. Empty cells are skipped, and dates or amounts appear exactly as you see them in Excel.

The result is saved as a cleaned copy of your file. Your original is not changed and nothing is uploaded.

Common questions about merging columns in Excel

How do I combine first name and last name in Excel?

Open your file, click First Name and then Last Name, choose a space as separator and give the new column a name. A preview shows the first row before anything happens. The result is, for example, John Smith.

What happens to empty cells when I merge columns?

Empty cells are skipped, so you never get double separators. Dates and numbers appear exactly as they look in Excel, for example 03/04/2026 or $1,250.00.

Where does the merged column appear?

The new column is added at the right end of your table. You can keep the original columns or remove them.

More free Excel cleanup tools

← View all tools