How to Combine Two Columns in Excel?

Sharing is caring!

Combining data from two columns is one of the most useful tasks in Microsoft Excel. Whether you want to merge first and last names, join city and state, or create a complete address, Excel offers several simple methods to do the job.

In this guide, you’ll learn how to combine two columns in Excel using formulas, built-in functions, and the Flash Fill feature. Each method works for different situations, helping you choose the fastest and most effective option.

Combine Two Columns Using the Ampersand (&) Operator

The ampersand (&) operator is one of the easiest ways to join text in Excel.

Basic Formula

If your data is in cells A2 and B2, use:

=A2&B2

This joins the contents without any space.

Example

Add a Space Between Words

To insert a space, include a space inside quotation marks.

=A2&" "&B2

Result:

You can also insert other characters.

The & operator works in almost every modern version of Microsoft Excel.

Use the CONCAT Function

The CONCAT function is a newer replacement for the older CONCATENATE function. It combines text from multiple cells into one.

Syntax

=CONCAT(text1, text2)

Example

=CONCAT(A2," ",B2)

Result:

John Smith

Unlike the ampersand operator, CONCAT can also combine multiple text strings more easily when working with several columns.

Example with Three Columns

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

If:

The result becomes:

John Smith, Manager

Combine Columns with the TEXTJOIN Function

If you use Excel 2019, Excel 2021, or Microsoft 365, TEXTJOIN is one of the most powerful options.

Syntax

=TEXTJOIN(delimiter, ignore_empty, text1, text2)

Example

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

Output:

John Smith

Why TEXTJOIN Is Helpful

The TEXTJOIN function can automatically ignore empty cells.

For example:

This prevents extra spaces from appearing in your combined text.

Combine Two Columns Without Using Formulas

If you only need the final values and not formulas, Flash Fill is a quick solution.

Steps

1. Enter the combined value manually in the first row.
2. For example, type John Smith.
3. Select the next empty cell.
4. Press Ctrl + E.
5. Excel automatically fills the remaining rows.

Flash Fill recognizes patterns and combines the columns for you.

This method is ideal for one-time data cleanup.

Replace Formulas with Values

After combining columns, you may want to keep only the finished text.

Follow these steps:

1. Select the cells containing the formulas.
2. Press Ctrl + C.
3. Right-click the selected area.
4. Choose Paste Special.
5. Select Values.

The formulas disappear, leaving only the combined text.

This is especially useful before sharing a workbook or exporting data.

Common Ways to Combine Excel Columns

The table below compares the most popular methods.

Common Mistakes to Avoid

Even simple formulas can produce unexpected results if you are not careful.

Forgetting Spaces

Using:

=A2&B2

creates:

JohnSmith

Instead, use:

=A2&" "&B2

Using the Wrong Function

Older versions of Excel may not support TEXTJOIN or CONCAT. If you are using Excel 2016 or earlier, the & operator or CONCATENATE function may be your best option.

Leaving Hidden Spaces

Extra spaces in your original data can create inconsistent results.

Use the TRIM function to remove unnecessary spaces.

=TRIM(A2)&" "&TRIM(B2)

This creates cleaner text and improves data quality.

Tips for Working with Combined Data

A few simple practices can make your spreadsheet easier to manage:

• Use cell references instead of typing text repeatedly.
• Keep the original columns until you verify the results.
• Use TEXTJOIN when working with optional or empty fields.
• Convert formulas to values before deleting the source columns.
• Check for extra spaces using the TRIM function.
• Save a backup copy before making large changes to your worksheet.

Vaishvi Desai

Vaishvi Desai is the founder of Excelsamurai and a passionate Excel enthusiast with years of experience in data analysis and spreadsheet management. With a mission to help others harness the power of Excel, Vaishvi shares her expertise through concise, easy-to-follow tutorials on shortcuts, formulas, Pivot Tables, and VBA.