To combine two columns in Excel, you usually put a formula in a new column that joins the values, then fill it down. Below is a blog-style guide in the format you requested.

How to Combine Two Columns in Excel (2026 Guide)

If you’ve got first and last names, area codes and numbers, or any pair of fields sitting side‑by‑side in Excel, you can quickly combine them into one column with simple formulas or built‑in tools.

Quick Scoop

  • Fastest method: use the & operator, like =A2 & " " & B2.
  • More flexible formulas: CONCAT, TEXTJOIN.
  • No‑formula trick: Flash Fill (great for casual users).
  • Power user option: Power Query for big or messy tables.

Think of it like building a full sentence from two words: you just tell Excel what to glue together and what to put in between.

Method 1: Using the & Operator (Fast and Simple)

This is usually the easiest way for everyday spreadsheets.

Step‑by‑step

  1. Add a new column where you want the combined result (for example, column C).
  2. In the first cell of that column (say C2), type a formula like:
    • With a space:
      • =A2 & " " & B2
    • With a comma and space:
      • =A2 & ", " & B2
  3. Press Enter – you’ll see the two cells combined as text.
  1. Drag the fill handle (small square at bottom‑right of the cell) down to fill the rest of the rows.

When to use this

  • Combining first and last names.
  • Joining city and state, or area code and phone number.
  • Quick one‑off fixes where you don’t need something fancy.

Method 2: CONCAT / CONCATENATE Functions

Excel has an older function CONCATENATE and the newer CONCAT. They work similarly to the & operator but look like a “proper” function.

Basic pattern

  • Old style:
    • =CONCATENATE(A2, " ", B2)
  • Newer style:
    • =CONCAT(A2, " ", B2)

Steps:

  1. In the new column (e.g., C2), type a CONCAT/CONCATENATE formula.
  2. Include your delimiter in quotes (space, comma, dash, etc.).
  3. Press Enter, then drag down to fill the rest.

Why pick CONCAT?

  • Cleaner for people who like function‑style formulas.
  • Works across multiple cells or ranges, not just two.

Method 3: TEXTJOIN (Best for Many Columns)

If you’re combining more than two columns or want to ignore blanks, TEXTJOIN is your power tool.

Core formula

Example to join A1 and B1 with a space and ignore blanks:

  • =TEXTJOIN(" ", TRUE, A1:B1)
  • First argument: delimiter (space, comma, dash).
  • Second argument: TRUE to ignore blanks.
  • Third argument: range of cells to combine (can be two columns or more).

Steps:

  1. In the target cell (say C1), enter the TEXTJOIN formula.
  2. Press Enter to see the combined result.
  3. Fill down for remaining rows.

When TEXTJOIN shines

  • Combining 3–5 columns into one (e.g., address lines).
  • Skipping empty cells without getting double spaces or dangling delimiters.

Method 4: Flash Fill (No Formulas)

Flash Fill lets you “show” Excel the pattern once, then it auto‑completes the rest for you.

How to use Flash Fill

  1. Suppose A2 has John and B2 has Doe. In C2, type John Doe.
  2. Start typing the next combined value in C3, or just press Ctrl + E.
  3. Excel will preview the pattern and fill the rest of the column with combined values.

You can also trigger it via:

  • Data tab → Flash Fill.

Pros and cons

  • Pros:
    • No formulas remain in the sheet.
    • Very intuitive; great for occasional jobs.
  • Cons:
    • Not dynamic – if source data changes, you must Flash Fill again.
    • Can misinterpret patterns if your examples are inconsistent.

Method 5: Power Query (For Big or Complex Data)

For larger datasets or repeated processes, Power Query gives you a more robust way to combine columns.

Basic flow

  1. Select your table or range that contains the two columns.
  2. Go to Data → Get & Transform → From Table/Range.
  3. In Power Query Editor, select the columns to combine.
  4. Choose Transform → Merge Columns.
  5. Pick a delimiter (space, comma, custom text) and a name for the new column.
  6. Click Close & Load to send the result back to Excel.

Why use Power Query?

  • Great for repeatable workflows (you can refresh instead of rebuilding).
  • Handles large datasets more gracefully than pure formulas.

“Combine” vs “Merge” Cells

One common confusion in forums: “combine columns” vs “merge cells.”

  • Combining columns: joins the values from two columns into one (methods above).
  • Merging cells: turns multiple cells into a single cell using Home → Merge & Center. This visually merges cells but keeps only one cell’s content.

When merging cells is okay

  • Formatting headers across multiple columns (like a big title over a table).
  • Not for data operations or lists – it can break sorting and filtering.

Common Forum Tips and Gotchas

From public discussions and help communities, users often mention:

  • Use =A2 & " " & B2 for everyday text joins; it’s simple and fast.
  • Flash Fill is a favorite for non‑technical users who don’t want to remember formulas.
  • For non‑overlapping datasets stacked into one column, users may build slightly more complex formulas or use Power Query, but the core idea remains: bring both sources into one list without arithmetic.

Side‑by‑Side View of Main Methods

[5][3][1] [1] [3][7][1] [1] [7][9][1] [1] [2][3][7][9][1] [2][1] [9][1] [1]
Method Example Formula / Action Best For Dynamic?
& operator =A2 & " " & B2 Simple text joins, two columns.Yes (updates with source cells).
CONCAT / CONCATENATE =CONCAT(A2, " ", B2) Cleaner formulas, 2+ cells.Yes.
TEXTJOIN =TEXTJOIN(" ", TRUE, A2:B2) Multiple columns, skipping blanks.Yes.
Flash Fill Type example → Ctrl + E One‑off tasks, no formulas.No (static values).
Power Query Data → From Table/Range → Merge Columns Large or repeated workflows.Yes (refreshable queries).

Mini FAQ (2026‑style)

Q: How do I combine two columns without adding numbers?
A: Treat them as text: use =A2 & " " & B2 or CONCAT(A2, " ", B2) instead of A2 + B2, which would sum numeric values.

Q: Which method is the most “future‑proof”?
A: CONCAT and TEXTJOIN are the more modern functions and are highlighted in recent tutorials and training content.

Q: Do I need the same Excel version as online tutorials?
A: Older versions may not have TEXTJOIN or CONCAT, in which case & and CONCATENATE remain reliable options.

TL;DR

  • For most people: use =A2 & " " & B2 in a new column and fill down.
  • For multi‑column joins with blanks: use TEXTJOIN.
  • For quick one‑offs with no formulas: use Flash Fill.

Bottom note: Information gathered from public forums or data available on the internet and portrayed here.