How to Combine Columns in Excel: 5 Easy Methods

To combine columns in Excel, enter =A2&" "&B2 in an empty cell and press Enter. This formula joins the values from columns A and B with a space between them.

You can also use CONCAT, TEXTJOIN, Flash Fill, or Power Query. Each method works differently, depending on whether you need a quick result, want to skip blank cells, or regularly clean large datasets.

Here’s how to combine your columns without losing important information.

Quick Answer: How to Combine Two Columns in Excel

Suppose you have first names in column A and last names in column B. You want to create full names in column C.

Follow these steps:

1. Open your Excel workbook.
2. Make sure column C is empty.
3. Click cell C2.
4. Enter =A2&" "&B2.
5. Press Enter.
6. Drag the fill handle down to apply the formula to the remaining rows.

Your worksheet will look like this:

The original names remain in columns A and B. Column C displays the combined results.

What Does Combining Columns Mean in Excel?

Combining columns means joining values from two or more cells into a single result.

For example, you might combine:

• First and last names into full names.
• Product codes and descriptions into inventory labels.
• Street names and cities into address fields.
• Department names and employee IDs into identification labels.
• Text and dates into report descriptions.

Combining data is different from moving or physically merging cells.

If you only need to change where a column appears in your worksheet, read our tutorial on how to move columns in Excel.

For combining information, the safest approach is to create a separate result column while keeping your original data intact.

Method 1: Combine Columns Using the Ampersand (&)

The ampersand operator is the easiest method for joining two Excel columns.

Step 1: Select an Empty Cell

Click C2 or another empty cell where you want the combined result.

Step 2: Enter the Formula

Type:

=A2&" "&B2

The formula has three main parts:

• A2 references the first value.
• & joins values together.
• " " inserts a space between them.

Step 3: Press Enter

If A2 contains Emma and B2 contains Wilson, C2 displays:

Emma Wilson

Step 4: Apply the Formula to Other Rows

Select C2 and drag the small square in its bottom-right corner down the column.

Excel adjusts the relative references for each row.

Combine Without Spaces

Use:

=A2&B2

Result: EmmaWilson

Combine With a Comma

Use:

=A2&", "&B2

Result: Emma, Wilson

Combine With a Hyphen

Use:

=A2&" - "&B2

Result: Emma – Wilson

Combine Three Columns

If A2, B2, and C2 contain three separate pieces of text, enter this formula in D2:

=A2&" "&B2&" "&C2

This method works well when all three fields contain values. If some are blank, TEXTJOIN is usually more convenient.

Method 2: Combine Columns Using CONCAT

CONCAT is an Excel function that joins text from individual cells or ranges.

To combine a first and last name, enter:

=CONCAT(A2," ",B2)

Press Enter and copy the formula down.

The result is the same as using the ampersand method.

Combine Multiple Cells With CONCAT

You can also combine an entire range:

=CONCAT(A2:C2)

Excel joins the contents without automatically inserting spaces.

For example, if the cells contain Red, Cotton, and Shirt, the result is:

RedCottonShirt

To add separators, specify them in the formula or use TEXTJOIN.

CONCAT vs. CONCATENATE

CONCATENATE is an older Excel function that remains available for compatibility.

Its formula looks like this:

=CONCATENATE(A2," ",B2)

Both functions can join text, but CONCAT supports ranges directly and is recommended for newer versions of Excel.

If you’re using an older workbook or Excel installation, check which functions your version supports.

Method 3: Combine Multiple Columns Using TEXTJOIN

TEXTJOIN is especially useful when combining three or more columns or working with missing information.

Suppose your worksheet contains:

Enter this formula in D2:

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

The formula contains three arguments:

• " " tells Excel to insert one space between values.
• TRUE tells Excel to ignore empty cells.
• A2:C2 identifies the cells to combine.

Your results will be:

Notice that James Anderson doesn’t contain an unwanted extra separator.

Combine Columns With Commas

To join several columns with commas, use:

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

This is helpful for simple lists, location labels, or inventory descriptions.

For full mailing addresses, consider using different separators between the street, city, state, and ZIP code.

Method 4: Combine Columns Without a Formula Using Flash Fill

Flash Fill recognizes patterns and automatically fills matching results.

It’s helpful when you want to combine names or other text without writing a formula.

How to Use Flash Fill

1. Keep first names in column A and last names in column B.
2. In C2, manually enter the complete name, such as Emma Wilson.
3. Start entering the next full name in C3.
4. If Excel displays a suggested list, press Enter to accept it.
5. Alternatively, select the output column and choose Data > Flash Fill.
6. Review the generated results.

In supported Excel desktop versions on Windows, you can use Ctrl + E to run Flash Fill.

Flash Fill Limitations

Flash Fill creates static values rather than formulas.

If you later change Emma to Emily in column A, the generated result may still say Emma Wilson.

Flash Fill can also misunderstand inconsistent names, unusual separators, or missing values.

Always review the completed output before removing the original columns.

Method 5: Combine Columns Using Power Query

Power Query is useful when you regularly import spreadsheets or repeat the same data-cleaning process.

Instead of rebuilding formulas every time, you can create a query and refresh it when the source data changes.

Step-by-Step Instructions

1. Select your dataset, including the column headings.
2. Open the Data tab.
3. Choose From Table/Range in supported Excel desktop versions.
4. Confirm the table range and headers.
5. Open Power Query Editor.
6. Make sure the columns you want to combine use the Text data type.
7. Select the relevant columns in the order you want.
8. Choose a merge method and separator.
9. Load the results back into Excel.
10. Refresh the query when your source data changes.

Option 1: Replace Original Query Columns

Select the relevant fields and choose:

Transform > Merge Columns

Choose a separator, such as Space, and enter a name for the merged column.

This replaces the selected columns in the query output. It does not simply create an extra result column alongside them.

Option 2: Keep Original Query Columns

If you want to retain the original query fields, use:

Add Column > Custom Column

For text columns named First Name and Last Name, you can enter:

[First Name] & " " & [Last Name]

Name the new column Full Name and confirm the result.

This creates another column while keeping the original query fields.

Power Query uses its own formula language, so don’t assume every ordinary Excel formula works inside its editor.

How to Combine Columns in Excel Without Losing Data

Combining information is usually safe when you work in a new column. Problems often happen when the original cells are deleted too early.

Use this process:

1. Save a backup of your workbook.
2. Keep the original data in its existing columns.
3. Create a separate output column.
4. Enter your combining formula.
5. Fill the formula down.
6. Check the output for blank values, extra spaces, and formatting issues.
7. Copy the completed results.
8. Use Paste Values to replace formulas with their current results.
9. Verify the values before deleting any source columns.

If you’re combining customer records or imported lists, you may also need to remove repeated entries. Our guide on how to remove duplicates in Excel explains how to clean duplicate records while protecting your data.

How to Convert Combined Formulas to Permanent Text

Formula results usually update when their referenced cells change.

If you want to keep the current combined results permanently, convert them into values.

1. Select the cells containing your completed formulas.
2. Press Ctrl + C on Windows, or copy using the Ribbon.
3. Keep the destination cells selected.
4. Open Home > Paste > Values.
5. Check the formula bar to confirm the results are now stored values.

For example, a cell previously containing =A2&" "&B2 will now contain Emma Wilson.

Important: Once pasted as values, the result will no longer update automatically when the original names change.

How to Combine Columns With Spaces or Commas

You can customize the separator using quotation marks in an Excel formula.

Suppose A2 contains ABC and B2 contains 123.

Quotation marks tell Excel to use the enclosed characters as literal text.

If your combined address or product description is too long to display clearly, learn how to wrap text in Excel without changing the underlying cell value.

How to Combine Columns and Skip Blank Cells

An ordinary ampersand formula can leave unwanted spaces when one of the source cells is empty.

For example:

=A2&" "&B2&" "&C2

If B2 is empty, the formula still inserts both spaces.

A better approach is:

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

This skips empty cells while placing a single separator between the remaining values.

However, a cell containing only spaces isn’t genuinely empty.

If your imported data contains unnecessary spaces, you can use:

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

TRIM removes ordinary leading, trailing, and repeated spaces. It doesn’t fix every type of invisible character found in imported data.

How to Combine Text, Numbers, and Dates

Excel stores dates and numbers differently from how they may appear on your worksheet.

When you combine them with text, their original display formatting may disappear.

Preserve Date Formatting

Suppose A2 contains Order Date and B2 contains a valid Excel date.

Use:

=A2&" "&TEXT(B2,"mm/dd/yyyy")

The result might be:

Order Date 10/25/2026

The TEXT function tells Excel exactly how to display the date.

Preserve Currency Formatting

If A2 contains Total and B2 contains 1250.5, use:

=A2&": "&TEXT(B2,"$#,##0.00")

Result:

Total: $1,250.50

Remember that this result is text, not a number you should use directly in calculations.

Preserve Five-Digit ZIP Codes

If a numeric ZIP code is stored in B2, try:

=A2&" "&TEXT(B2,"00000")

A value of 1234 becomes 01234 in the resulting text.

This approach assumes the source represents a five-digit ZIP code.

For ZIP+4 codes, long identifiers, or codes with significant leading zeros, store the original information as text before importing it into Excel.

Formatting cannot always restore digits Excel has already discarded.

How to Combine Columns in Excel on Mac or Online

The ampersand, CONCAT, and TEXTJOIN approaches work in supported modern Excel versions on Windows, Mac, and the web.

Excel on Mac

Enter your formula in an empty cell, press Return, and fill it down.

Flash Fill is available in supported desktop versions of Excel for Mac. Look for the Flash Fill command on the Data tab.

Power Query capabilities depend on your Excel edition and update level.

Excel Online

You can combine data with supported formulas and copy the results down.

To preserve the output, use the available Paste Values command.

Some desktop features and menu options may differ in Excel for the web.

Why Is My Excel Combine Columns Formula Not Working?

Here are the most common problems and their fixes.

1. Missing Spaces Between Words

If your result looks like EmmaWilson, add a space between quotation marks:

=A2&" "&B2

2. Extra Spaces

Use TEXTJOIN to skip empty fields. For ordinary unwanted spaces inside text, consider TRIM.

3. #NAME? Error

Check whether you’ve misspelled a function or your Excel version doesn’t support it.

If CONCAT or TEXTJOIN isn’t available, try an ampersand formula.

4. #VALUE! Error

Check whether source cells already contain errors or whether the combined text exceeds Excel’s 32,767-character cell limit.

5. Dates Appear as Numbers

Use TEXT with the required date format:

=TEXT(B2,"mm/dd/yyyy")

6. Leading Zeros Disappear

Store identifiers as text before importing them. Use a suitable TEXT format only when the stored number still contains enough information.

7. Results Don’t Update

Flash Fill and pasted values are static. Use a formula when you need automatic recalculation.

8. Results Disappear After Deleting Columns

If your formulas still reference deleted cells, they may return #REF!.

Restore the source data if possible, then use Paste Values before deleting it.

9. Flash Fill Produces Incorrect Results

Provide more consistent examples and review the generated output.

10. Power Query Shows Old Data

Check the source range, then refresh the query.

Tip: Depending on your regional settings, Excel may require semicolons rather than commas between formula arguments.

Combine Columns vs. Merge Cells: What’s the Difference?

Combining text and merging cells are not the same operation.

Warning: Don’t use Merge & Center to combine first names and last names stored in separate populated cells.

When merging populated cells, Excel retains the upper-left cell’s value in a standard left-to-right worksheet and discards the other selected cell values.

If your goal is to join names or other information, use CONCAT, TEXTJOIN, or the ampersand operator instead.

Which Excel Column-Combining Method Is Best?

For most beginners, the ampersand method is enough.

Choose TEXTJOIN when your data contains optional fields, and Power Query when you’re repeating the same cleanup across regularly updated datasets.

Common Mistakes When Combining Columns

These mistakes can cause incorrect results or lost information:

• Using Merge & Center to join text values.
• Deleting the source columns while formulas still reference them.
• Forgetting spaces, commas, or other separators.
• Failing to inspect blank cells.
• Assuming Flash Fill automatically recalculates.
• Losing number or date formatting.
• Treating ZIP codes and product IDs as ordinary numbers.
• Overwriting occupied cells with combined results.
• Choosing Transform > Merge Columns when you wanted to retain both query fields.
• Skipping the final review of the combined data.

For important workbooks, make a copy before changing the original structure.

Frequently Asked Questions

How do I combine two columns in Excel?

Enter =A2&" "&B2 in an empty result cell and copy it down.

What formula combines columns with a space?

Use =A2&" "&B2 or =CONCAT(A2," ",B2).

How do I combine multiple columns?

Use =TEXTJOIN(" ",TRUE,A2:D2) to join four columns with spaces while skipping empty cells.

Can I combine columns without losing data?

Yes. Keep the source columns, create a separate result column, and convert formulas to values before deleting any original fields.

How do I merge first and last names?

Use the ampersand operator or Flash Fill to create full names in another column.

What does CONCAT do in Excel?

CONCAT joins text from multiple cells or ranges without automatically adding separators.

What’s the difference between CONCAT and TEXTJOIN?

TEXTJOIN lets you define a delimiter and skip empty cells. CONCAT doesn’t provide those options directly.

How can I combine columns without formulas?

Use Flash Fill in a supported desktop version of Excel.

How do I use Flash Fill?

Type one or more sample results, then choose Data > Flash Fill and verify the output.

Can Excel ignore blank cells when combining text?

Yes. Set the second TEXTJOIN argument to TRUE.

How do I combine dates with text?

Use TEXT inside your formula to control the date format.

How do I preserve leading zeros?

Store identifiers as text. For appropriate numeric values, use TEXT with a suitable format code.

How do I make combined results permanent?

Copy your formula results and use Paste Values.

Does Merge & Center delete data?

It can. When multiple selected cells contain values, Excel retains one cell’s contents and removes the others.

Why am I getting #NAME? or #VALUE!?

Check function availability, spelling, source errors, formula separators, and text-length limits.

Can I combine Excel columns on Mac or online?

Yes. Supported formulas work in modern Mac and browser-based Excel versions, although some tools and interfaces differ.

Conclusion

Combining columns in Excel doesn’t have to be complicated. The ampersand operator is the simplest way to join two cells, while CONCAT and TEXTJOIN offer useful alternatives for larger or less consistent datasets.

Flash Fill works well for one-time tasks, and Power Query is helpful for repeatable data cleaning.

Whichever method you choose, keep your original information until you’ve checked the combined results. Use Paste Values before deleting source columns to avoid breaking formulas.

Read more