"How to Merge Two Columns in Excel Easily and Quickly"

Christopher Jun 16, 2026

Merge Two Columns in Excel: A Step-by-Step Guide

Merge Two Columns in Excel
Merge Two Columns in Excel

Merging two columns in Excel is a common task that can be accomplished in a few different ways, depending on the desired outcome and the version of Excel you're using. Whether you're a seasoned Excel user or just starting out, this guide will walk you through the process of merging two columns using the most common methods.

How to merge or combine two columns in Microsoft Excel
How to merge or combine two columns in Microsoft Excel

Why Merge Columns in Excel?

Merging columns in Excel can be useful in a variety of situations, such as:

How to Merge Two Columns into One
How to Merge Two Columns into One
  • Combining names and titles in a contacts list
  • Creating a single column for addresses
  • Merging data from multiple columns into a single column for analysis

By merging columns, you can reduce data clutter, make your spreadsheets easier to read and use, and improve data analysis and reporting.

How to merge data from two different columns in Excel
How to merge data from two different columns in Excel

Merging Columns Using the Concatenate Function

The most straightforward way to merge two columns in Excel is to use the CONCATENATE function. This function combines text strings from two or more cells into a single cell.

To use the CONCATENATE function, follow these steps:

Merge Two Columns in Excel
Merge Two Columns in Excel
  1. Select the cell where you want to merge the columns
  2. Go to the formula bar and type "=CONCATENATE(A1:B1)" (assuming the columns you want to merge are in cells A1 and B1)
  3. Press Enter to apply the function

Alternatively, you can use the "&" symbol to concatenate the values from two cells, like this: "=A1&B1". This method is quicker and easier, but less flexible than the CONCATENATE function.

Merging Columns Using the Ampersand (&) Symbol

How to merge two columns in excel?
How to merge two columns in excel?

An alternative to the CONCATENATE function is to use the "&" symbol to merge two columns. This method is quicker and easier, but less flexible.

To use the "&" symbol, follow these steps:

How to merge two columns in excel?
How to merge two columns in excel?
Excel Merge Two Columns Tutorial
Excel Merge Two Columns Tutorial
How to merge and combine Excel spreadsheets into one
How to merge and combine Excel spreadsheets into one
How to Transpose Column to Multiple Rows in Excel (6 Methods)
How to Transpose Column to Multiple Rows in Excel (6 Methods)
How to Combine Two Columns in Microsoft Excel
How to Combine Two Columns in Microsoft Excel
How To Combine Two Columns In Excel
How To Combine Two Columns In Excel
How to Merge two Columns in Excel
How to Merge two Columns in Excel
How to Unhide Column A in Excel
How to Unhide Column A in Excel
How to Merge Two Columns in Excel Together
How to Merge Two Columns in Excel Together
How to Merge Excel Files Based on Column (3 Methods)
How to Merge Excel Files Based on Column (3 Methods)
calculate gst in excel, how to calculate gst, gst calculator, gst calculator in excel
calculate gst in excel, how to calculate gst, gst calculator, gst calculator in excel
How to Transpose data from rows to columns in excel
How to Transpose data from rows to columns in excel
How To Combine Two Columns In Excel Without Losing Data | CellularNews
How To Combine Two Columns In Excel Without Losing Data | CellularNews
HOW TO COMPARE TWO COLUMNS IN EXCEL
HOW TO COMPARE TWO COLUMNS IN EXCEL
How to Compare Two Columns in Excel Using VLOOKUP
How to Compare Two Columns in Excel Using VLOOKUP
an image of a computer screen with numbers and symbols on it, including the number line
an image of a computer screen with numbers and symbols on it, including the number line
3 ways to merge columns in Excel into one
3 ways to merge columns in Excel into one
How to Select Non-Adjacent Columns in Excel
How to Select Non-Adjacent Columns in Excel
an orange and green sign that says compare 2 columns fast on the bottom right hand corner
an orange and green sign that says compare 2 columns fast on the bottom right hand corner
How to Combine Two Columns in Microsoft Excel
How to Combine Two Columns in Microsoft Excel
  1. Select the cell where you want to merge the columns
  2. Type "=" followed by the "&" symbol
  3. Type the cell reference for the first column, followed by the "&" symbol and the cell reference for the second column
  4. Press Enter to apply the function

For example, if you want to merge columns A and B, you would type "=A1&B1".

Merging Columns Using the Flash Fill Feature (Excel 2013 and Later)

Excel 2013 and later versions offer a feature called Flash Fill, which allows you to quickly merge two columns with similar data by copying and pasting the data into a new column.

To use the Flash Fill feature, follow these steps:

  1. Select the cells that contain the data you want to merge
  2. Copy the cells by pressing Ctrl+C (or Cmd+C on a Mac)
  3. Right-click on the cell where you want to merge the columns and select "Flash Fill"
  4. Excel will automatically create a new column with the merged data

Merging Columns Using a Formula (Excel 2010 and Earlier)

If you're using an earlier version of Excel, you can still merge two columns using a formula.

To use a formula to merge two columns, follow these steps:

  1. Select the cell where you want to merge the columns
  2. Go to the formula bar and type "=CONCATENATE(A1,": (assuming the columns you want to merge are in cells A1 and A2)
  3. Drag the formula down to the other cells in the column

Alternatively, you can use the "&" symbol to concatenate the values from two cells, like this: "=A1&A2".

Tips and Variations

Here are some additional tips and variations to keep in mind when merging columns in Excel:

  • Use the CONCATENATE function with multiple arguments to merge more than two columns
  • Use the "&" symbol with multiple cell references to concatenate multiple cells
  • Use the Flash Fill feature to quickly merge columns with similar data
  • Use a formula to merge columns when you need to perform more complex operations, such as concatenating values with different data types

By following these steps and tips, you can quickly and easily merge two columns in Excel, regardless of the version you're using or the complexity of your data.