You can merge two columns in Excel either by combining their values into one column (most common) or by literally merging cells for layout (like a wide header). Here’s a clear, SEO‑friendly guide you can use as a blog post.

How to Merge Two Columns in Excel (Without Losing Data)

If you’ve ever stared at two separate columns in Excel—like first name and last name—and wished they were one, you’re not alone. In 2026, this is still one of the most searched “everyday Excel problems” online. Below are the easiest ways to merge two columns in Excel without losing data, plus when each method makes the most sense.

Quick Scoop (Fast Answer)

If you just want the fastest, no‑nonsense solution:

  1. Insert a new column where you want the merged result.

  2. In the first cell, type a formula like:
    =A2 & " " & B2

    • A2 = first column
    • B2 = second column
    • " " = space between them

  3. Press Enter.

  4. Drag the fill handle down to apply to all rows.

  5. (Optional) Copy the merged column → right‑click → Paste Special → Values to keep only the text.

That’s it. You’ve merged two columns into one without deleting the originals.

Method 1: Merge Two Columns with & (Ampersand)

This is the simplest and most universal method; it works in basically all Excel versions.

When to use this

  • You want to combine text (e.g., first + last name, city + state).
  • You want the result to update automatically when source cells change.
  • You need a quick, formula‑based solution.

Steps

  1. Add a new column
    Insert a blank column where you want the merged data (for example, column C titled “Full Name”).

  2. Write the formula In cell C2, type:

    text

=A2 & " " & B2
    • Replace " " with ", " or " - " if you want commas or dashes instead of spaces.

  3. Fill down

    • Hover over the bottom‑right corner of the cell (little square).
    • When the cursor turns into a cross, double‑click or drag down.

  4. Lock in values (optional) If you no longer need the formulas:

    • Select the merged column.
    • Copy.
    • Right‑click → Paste Special → Values.

Pros and cons

  • Pros: Very easy , works in all versions, fully dynamic.
  • Cons: Can get messy if you need many separators or conditional logic.

Method 2: Use CONCAT / CONCATENATE Function

This is a more “formal” version of the & method.

When to use this

  • You’re comfortable with functions and want slightly cleaner formulas.
  • You’re combining more than two columns frequently.

Basic patterns

  • Older versions: CONCATENATE
  • Newer versions (Excel 2019 / Microsoft 365): CONCAT

Example for two columns:

text

=CONCAT(A2, " ", B2)

Older Excel:

text

=CONCATENATE(A2, " ", B2)

Steps

  1. Insert a new column.
  2. In the first cell, enter =CONCAT(A2, " ", B2).
  3. Press Enter.
  4. Fill the formula down.
  5. Optional: Convert formulas to values.

When this shines

  • Merging three or more columns , e.g.:

    text

=CONCAT(A2, " - ", B2, " (", C2, ")")

Method 3: Use TEXTJOIN (Best for Many Columns)

TEXTJOIN is a modern function that’s great when you have several columns or want to ignore blanks.

Note: TEXTJOIN is available in Excel 2019 and Microsoft 365.

Syntax

text

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

For two columns:

text

=TEXTJOIN(" ", TRUE, A2, B2)
  • " " = space between items.
  • TRUE = ignore empty cells.
  • A2, B2 = the cells to combine.

You can also use a range:

text

=TEXTJOIN(" ", TRUE, A2:B2)

When to use

  • You have many columns to merge.
  • Some cells are blank and you don’t want extra spaces or separators.
  • You need flexible delimiters (spaces, commas, line breaks, etc.).

Method 4: Use Flash Fill (No Formulas)

Flash Fill is like Excel trying to “guess the pattern” for you. It’s great when you want a quick one‑time merge and don’t need formulas.

When to use this

  • You just want a static result.
  • Your pattern is consistent (e.g., FirstName LastName for every row).
  • You’re working in Excel 2013 or newer (where Flash Fill exists).

Steps

  1. Insert a new column.

  2. In C2, manually type how the merged value should look, e.g.:
    John Smith

  3. Go to the next row (C3) and start typing the next combined value (e.g. Mary J...).

  4. Excel often shows a gray preview for the whole column.

  5. Press Enter to accept Flash Fill.
    If it doesn’t auto‑suggest:

    • Go to Data → Flash Fill , or
    • Press Ctrl + E.

Pros and cons

  • Pros: No formulas, very fast for one‑off tasks.
  • Cons: Not dynamic; if source data changes, merged values do not update.

Method 5: Merge & Center (Only for Layout / Headers)

This is the one many beginners try first—and it’s often the wrong one for merging data. Important: “Merge & Center” merges cells , not data from two columns into one list. It will keep only the top‑left cell’s value and discard the rest.

When it’s appropriate

  • Creating headers that span multiple columns, like a title over several columns.

Steps

  1. Type your header in the leftmost cell (e.g., A1).
  2. Select the cells you want to merge (e.g., A1:C1).
  3. Go to the Home tab.
  4. Click Merge & Center.

Why not use this for data columns?

  • If you select two data cells with different values and click Merge, only one value survives.
    For combining content , always prefer formulas or Flash Fill.

Step‑by‑Step Example: Combine First and Last Names

Let’s say your sheet looks like this:

  • Column A: First Name
  • Column B: Last Name

You want a “Full Name” column.

Using &

  1. Insert a new column C labeled Full Name.

  2. In C2, enter:
    =A2 & " " & B2

  3. Press Enter.

  4. Drag down.

Result: “John Smith”, “Mary Jones”, etc., all in one column.

Using TEXTJOIN

  1. In C2, enter:
    =TEXTJOIN(" ", TRUE, A2, B2)

  2. Press Enter, then drag down.

Functionally similar, but more flexible if you later add middle names or extra columns.

Common Pitfalls to Avoid

  • Accidentally using “Merge & Center” on real data
    This deletes all but one cell’s value. Use it only for visual layout , not data merging.

  • Forgetting to convert formulas to values
    If you plan to delete the original columns, you must copy the merged column and paste as values first.

  • Extra spaces or separators

    • Using & " " & when one column is blank can leave double spaces.
    • TEXTJOIN with TRUE helps avoid this by ignoring empty cells.

  • Version mismatch

    • TEXTJOIN and CONCAT won’t work in very old Excel versions.
    • If unsure, stick to &—it’s universal.

Mini “Forum‑Style” Q&A

Q: “I have hundreds of rows—do I really have to do this manually?”
A: No. Put the formula in the first merged cell and drag down. Excel will handle all rows in seconds.

Q: “Can I merge two columns into one and then delete the originals?”
A: Yes, but first copy → Paste Special → Values in the merged column so you don’t lose the results.

Q: “What if my columns are numbers, not text?”
A: These formulas still work. If you want them to remain numeric separately, keep your original numeric columns and treat the merged one as a display field.

SEO Corner: Where This Is Trending

Every year, “how to merge two columns in Excel ” stays a top query because:

  • New users keep joining the workforce and discovering Excel.
  • Microsoft keeps adding functions (TEXTJOIN, CONCAT), but older how‑tos often only mention CONCATENATE.
  • People frequently work with exported data (CRMs, web forms) that come as separate first/last names, addresses, etc.

This makes it a great evergreen blog topic with consistent search interest.

TL;DR (Summary)

  • For most users , use:
    =A2 & " " & B2
    Then drag down and optionally paste as values.

  • Use CONCAT or TEXTJOIN in modern Excel if you’re merging many columns or need to ignore blanks.

  • Use Flash Fill for quick, static one‑time merges.

  • Use Merge & Center only for visual headers , not for combining data.

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