How to Combine Two Columns in Excel, Step by Step

Picture a sheet with first names in column A and last names in column B, and a teammate who needs full names in one column by end of day. Retyping them would eat your afternoon.

Combining two columns means joining their contents into a single column, and Excel gives you several ways to do it.

In this post, we’ll cover the formulas, the tools, and a quick guide to picking the right one. You’ll also get the keyboard-first routes, like Ctrl+E, that keep your hands off the mouse.

Why and When to Combine Two Columns

Spreadsheets often split one piece of information across several columns. Combining columns turns those pieces into one usable value.

Where people combine columns most

Some common jobs look like this:

• First and last names. Sort by last name, then join the two into a full name.
• City and state. One column is easier to scan and paste than two.
• Addresses across columns. Street, city, state, and postal code join into one line for a shipping label.
• Merging datasets and contact lists. One shared field makes matching records easier.

Picture a support agent working from a home office, with first names in column A and last names in column B. One formula, copied down, builds every full name at once. Hands stay on the keys.

A common question is how to merge multiple cells. This works for more than two columns too: add each one to the formula, or use TEXTJOIN, which joins a whole range of cells in one step.

Combining the contents of cells isn’t the same as merging them, which changes the layout.

What you gain by combining

Here’s what combining gets you:

• Better data organization. Each record holds one complete value, which is easier to sort and filter.
• Saves time. One formula handles every row, so you aren’t retyping each one.
• Easier large-dataset management. A copied-down formula is easier to check than many hand-typed cells.
• Clearer analysis. Complete, clean values mean fewer workarounds when you filter or summarize.

The real gain isn’t the formula itself but the time you stop spending on cleanup. That’s the payoff we’re after.

Joining Columns with Formulas

Formulas update whenever the source cells change. Here’s how we’ll go through each method and the Excel version it needs.

How do I merge first and last names?

To merge first and last names, use the ampersand (&). Say you’re a freelance bookkeeper working from home, with first names in column A and last names in column B. In cell C2, type =A2&" "&B2 and press Enter.

The ampersand joins the cells with a space between them, so Maya in A2 and Chen in B2 become Maya Chen, ready to paste into invoices.

For Chen, Maya, swap in a comma and space: =B2&", "&A2. It works in every version of Excel.

Numbers, dates, and currency need one extra step. Wrap them in TEXT with a format code, such as TEXT(E2,"mm/dd/yyyy") for a date or TEXT(F2,"$#,##0.00") for money, so they join with the format you chose.

In Microsoft 365, skip copying the formula down. Type =A2:A20&" "&B2:B20 once in the top cell, not in every row, and the results spill down the column. One formula, and the list fills itself.

Join many columns with TEXTJOIN

For more than two columns, TEXTJOIN is the better tool. Its first argument is the delimiter, the character between each piece, and you set it just once: =TEXTJOIN(" ",TRUE,A2:C2) joins a first, middle, and last name with one space between each part.

The second argument is the ignore-empty option. Set it to TRUE, and Excel skips blank cells rather than adding a separator for them, so a missing middle name doesn’t leave a double space.

It also suits many columns, where a chain of ampersands gets unwieldy.

CONCAT replaces the older CONCATENATE

CONCAT is the newer version of CONCATENATE and joins text the same way. Its separator is one you type yourself, not one Excel adds for you: =CONCAT(A2," ",B2).

Older workbooks may still use CONCATENATE, which Excel keeps for backward compatibility. Use CONCAT for anything new.

Pick a separator that fits your data

The separator sits between the joined pieces, and the right one depends on how the result will be read. Common choices include:

• Space, for full names: " "
• Comma, for Last, First listings: ", "
• Dash, for quick labels: " - "
• Slash, for pairs such as North/South: "/"

Whatever you pick goes inside double quotes. The ampersand and CONCAT have no separator option, so changing it means editing each formula. TEXTJOIN keeps it in one argument, so changes are easier.

Which Excel versions support each method

Your version decides which method you can use:

• The ampersand and CONCATENATE work in every version.
• TEXTJOIN needs Excel 2019 or Microsoft 365.
• Dynamic arrays, the feature behind spilling, need Microsoft 365 or Excel 2021.
• In older versions, enter the formula in the first row and copy it down the column.

When in doubt, the ampersand is your safe bet.

Finish the Combined Column Step by Step

The formula is the easy part, so here’s how we’ll finish the job.

Set up a helper column first

Start with a helper column, a spare column that keeps your originals untouched:

• Insert a blank column next to your two source columns.
• In the first data row, enter your formula, such as =A2&” “&B2.
• Label it clearly, like “Full Name,” so anyone can tell what it holds.

Drag the formula down every row

Grab the fill handle (the small square at the cell’s bottom-right corner) and drag it to your last row. You’re copying the formula, not the answer, so Excel adjusts the cell references as it goes: A2 becomes A3. Nothing to retype.

Other routes work too:

• Copy and paste: Select the formula, press Ctrl+C, then select the cells below and press Ctrl+V.
• Fill down: Select the formula and the cells beneath it, then press Ctrl+D.
• Spill in dynamic arrays: In newer Excel versions with dynamic arrays, one formula can fill neighboring cells on its own, as long as they stay empty.

Turn formulas into plain values

Formulas are live, values are fixed. Lock in the results before you touch the originals. Do this in order:

1. Copy the combined column. Select it and press Ctrl+C.
2. Paste as values. Select the top cell, right-click, choose Paste Special, then Values. Or press Ctrl+Alt+V, then V.
3. Remove the dependency. The column no longer needs columns A and B.
4. Then delete the originals. Check the results, then delete the source columns.

Consider a home office worker building a mailing list from first names in column A and last names in column B. Once the full names are pasted as values, deleting both originals won’t break the list.

Shortcuts and tips to work faster

• Ctrl+C and Ctrl+V: Every copy and paste above stays on the keyboard.
• Autosave in ONLYOFFICE: Switch on autosave before you start, so you’re not relying on memory to save.
• Experiment with delimiters: Swap in =A2&”, “&B2 for a comma or =A2&”-“&B2 for a hyphen, and keep whatever reads best.
• Mac and Windows differences: Use Cmd where Windows uses Ctrl, and check your own menu for Paste Special, since its shortcut differs.

Ways to Combine Without Formulas

Not every combine needs a formula. Some routes take one keystroke, others a few clicks, and each trades setup for a different result.

Let Flash Fill guess the pattern

Flash Fill watches what you type and completes the column for you. Say first names sit in column A and last names in column B. Type the full name you want in cell C2, then press Ctrl+E. Prefer the ribbon? It’s also on the Data tab.

Flash Fill returns static text, not a live formula, so results won’t update if column A changes. If Excel guesses wrong, type a second example in the next row.

Consider a home office bookkeeper with a client list split across two columns. One typed example and a press of Ctrl+E fills every row without touching the mouse. Working in Google Sheets?

The formula equivalent is =A2&” “&B2, which joins the cells with a space.

Combine columns with Power Query

Power Query is Excel’s built-in tool for reshaping data. Here’s the route:

1. Select your data, press Ctrl+T to convert it to a Table, then choose Data > From Table/Range.
2. Select both columns, choose Merge Columns from the Transform tab, and pick a custom separator such as a comma or space.
3. Click Close & Load to place the result on a new sheet.

The output is refreshable, not fixed. When the source changes, go to Data and click Refresh All (Ctrl+Alt+F5).

A quick Notepad workaround

For a one-time combine, Notepad is the fastest route. Copy both columns and paste them into Notepad, where a tab separates each pair of values. Press Ctrl+H, swap each tab for your separator, then copy the text and paste it back into Excel.

It’s a one-time fix, not a live link. Quick, but not permanent.

Automate it with a VBA macro

For a task you repeat, a VBA macro (short for Visual Basic for Applications, the programming language built into Excel) can do it on demand. Press Alt+F11 to open the Visual Basic Editor, then choose Insert and Module.

The macro loops through each row, joins the two values, and writes plain values into a new column. Those values won’t update when the source does, so save the file as .xlsm to keep the macro with it.

A support lead who combines ticket numbers and customer names every Monday can build this once and run it in a single step.

Mistakes to Avoid When Combining

Most combining mistakes come from picking the wrong method. Here’s where people usually stumble.

Why Merge & Center loses your data

Merge & Center feels like the quick fix, but it’s built for formatting, not for joining values. It keeps only the upper-left value and discards everything else. Excel shows a warning, which is easy to click past. That’s the trap.

Consider a support agent who merges a first name and last name column this way. The whole list collapses into one cell holding a single name. Ctrl+Z is your fastest way back, so use a formula in a new column instead.

Surprises that trip people up

Watch for these quirks:

• Result is always text. Joined values come out as text, so SUM skips them.
• Double spaces from blanks. An empty middle name cell leaves two spaces in a row.
• Deleting originals breaks formulas. Formulas point at their source cells, so deleting the source columns triggers #REF! errors.
• Static vs updating results. Formulas update when the source changes, but Flash Fill (Ctrl+E) and pasted values stay frozen.
• Messy data. Stray trailing spaces survive a join, so wrap your formula in TRIM.

Picture a home office analyst merging full names from a contact list. TRIM removes every double space in one pass, so there’s no row-by-row cleanup.

Which method fits your situation

Pick by scenario:

• One-time cleanup: Flash Fill is quickest, but it’s static and won’t cover new rows.
• A sheet you’ll keep editing: Formulas with & or TEXTJOIN update on their own. Copy them down for new rows.
• A recurring report: Power Query reruns the combine on new rows when you refresh, so nothing gets rebuilt.

To split a combined cell back apart, select the column, open the Data tab, and choose Text to Columns. Pick Delimited, then your delimiter, like a comma or a space.

For full names, choose Space and check that middle names and suffixes landed where you expected.

Where ONLYOFFICE Fits In

Not everyone who combines columns works in a desktop copy of Excel, so it’s worth knowing where another tool fits. The one this article uses as its example is ONLYOFFICE Spreadsheet Editor.

ONLYOFFICE Spreadsheet Editor

Three things matter for this topic:

• Excel formats. It supports Excel formats, so the spreadsheets you already have are the ones you work with.
• Online collaboration. Because the editor works online, teammates can work in the same file with you instead of passing copies back and forth.
• Example tool. The steps in this article use it as the example, so each method runs on the same kind of data.

Consider a home office bookkeeper who keeps a client list with first names in column A and last names in column B. They need one full-name column for invoices.

If the file lives online, they can make that change during a call while a coworker checks the same sheet from another location, and nobody has to email a fresh copy. One file, one version.

The focus is on what each method does, not on which program happens to be open.

Combining two columns in Excel comes down to matching the method to the job. An ampersand or TEXTJOIN formula covers most joins, while Flash Fill and Power Query shine when patterns get messy.

Keep the keyboard routes close, because a few keystrokes can finish the job without a trip to the mouse.

Once the combined column looks right, lock it in and move on. The next time two columns need to become one, your hands already know the way.