How to Combine Two Columns in Excel

Vimal Kumar
Vimal Kumar·
How to Combine Two Columns in Excel

What is Microsoft Excel?


Microsoft Excel is a versatile spreadsheet program developed by Microsoft, used widely for data analysis, financial calculations, and visualization. It provides a range of functions to organize and manage data efficiently, making it a vital tool for both personal and professional use.

Excel screenshot

Who is Microsoft Excel best suited for?


Microsoft Excel is best suited for Product Marketers, data analysts, accountants, and business professionals. It facilitates creating detailed financial reports, tracking sales and inventory, and analyzing data trends, thus enhancing decision-making and strategic planning.

How to Combine Two Columns in Excel

Interactive demo powered by Supademo

Common FAQs on How to Combine Two Columns in Excel

Commonly asked questions about this topic.

How can I combine two columns in Excel using a formula?

You can use the CONCATENATE function or the ampersand (&) operator to combine two columns. For example, in cell C1, you can enter =A1&B1 or =CONCATENATE(A1, B1).

What is the difference between CONCATENATE and CONCAT?

CONCAT is an updated version introduced in Excel 2016 that can combine ranges of cells. CONCATENATE is an older function and handles only individual cell references. Both can be used to combine text, but CONCAT is more versatile.

Can I add a space or a comma when combining two columns in Excel?

Yes, you can include separators like spaces or commas within the formula. For example, use =A1 & " " & B1 to add a space or =A1 & ", " & B1 to add a comma between values from two columns.

Is there a way to combine two columns without using a formula?

Yes, you can use the Flash Fill feature available in Excel 2013 and later. Type the desired combination result next to your first entry, then go to Data > Flash Fill or press Ctrl + E.

How do I combine two columns and ignore blank cells?

You can use an IF statement to check for blank cells. For example, use =IF(A1 = "", B1, IF(B1 = "", A1, A1 & " " & B1)) to concatenate two columns while ignoring blanks. Adjust the formula to handle the blanks according to your needs.

Enjoyed this interactive product demo of Microsoft Excel?

Create your own interactive product demo in minutes. Drive growth, scale enablement and supercharge product led-onboarding with Supademo. Sign up for free here with no credit card required.
Vimal Kumar

Vimal Kumar

Product Operations Associate

Vimal Kumar helps build and grow Supademo’s team and GTM efforts, with a focus on figuring out growth levers and improving product traction.

More from the blog

How to Remove 'Powered by Shopify'

How to Remove 'Powered by Shopify'

Learn how to easily remove the 'Powered by Shopify' text from your online store with step-by-step instructions and tips to customize your Shopify storefront.

Vimal Kumar
Vimal KumarJan 3, 2026
How to Add Products to Shopify

How to Add Products to Shopify

Learn step-by-step how to add products to your Shopify store effortlessly, including tips on product details, images, pricing, and inventory management to boost your online sales.

Vimal Kumar
Vimal KumarDec 17, 2025
How to Deactivate Your Shopify Store

How to Deactivate Your Shopify Store

Learn step-by-step how to deactivate your Shopify store easily, including important considerations and tips to pause or close your shop without losing data.

Vimal Kumar
Vimal KumarDec 17, 2025
How to Remove 'Powered by Shopify'

How to Remove 'Powered by Shopify'

Learn how to easily remove the 'Powered by Shopify' text from your online store with step-by-step instructions and tips to customize your Shopify storefront.

Vimal Kumar
Vimal KumarDec 17, 2025
How to Create a Shopify Account

How to Create a Shopify Account

Learn step-by-step how to create a Shopify account quickly and easily, set up your online store, and start selling your products in no time.

Vimal Kumar
Vimal KumarDec 17, 2025
How to Create a Stripe Account

How to Create a Stripe Account

Learn how to create a Stripe account quickly and easily with our step-by-step guide, perfect for beginners looking to start accepting online payments.

Vimal Kumar
Vimal KumarDec 17, 2025