gadget-bridge
HomeHow ToHow to Combine Two Columns in Microsoft Excel?

How to Combine Two Columns in Microsoft Excel?

Use these two easy functions to combine any two columns.

- Advertisement -

If you’ve just started using Microsoft Excel, there are a host of functions that you might not be aware of. These functions are super easy to use and will make your Excel experience much easier. One of these functions lets you combine the data within two cells. This saves you the hassle of manually entering merged data into a third cell. You can also combine two entire columns. Today, we will show you how to combine two columns in Microsoft Excel.

Read Also: How to create a checklist in Excel

Using the Ampersand Symbol (&) to combine two columns in Microsoft Excel

Step 1: Select the cell in which you want to place the combined data.

- Advertisement -

Select the cell in which you want to place the combined data. Combine Two Columns in Microsoft Excel

Step 2: Type ‘=’ and select the first cell you wish to combine.

- Advertisement -

Step 3: Type ‘&’ followed by quotation marks (“ “) with a space enclosed between them. This is done to separate your data entries with a space. If you do not want a space between your entires, skip the quotation marks.

Step 4: Select the other cell you want to combine. For example – if you’re combining the data of A3 and B3 cells, your formula must look like =A3&” “B3.

Select the other cell you want to combine

Step 5: Press Enter. Excel will merge your data.

Press Enter. Excel will merge your data.

Using the CONCAT function to combine two columns in Microsoft Excel

Step 1: Select the cell in which you want to place the combined data.

Select the cell in which you want to place the combined data.

Step 2: Type =CONCAT(

Type =CONCAT( Combine Two Columns in Microsoft Excel

Step 3: Select the first cell you want to combine followed by a comma to register the entry.

Step 4: Place two quotation marks (“ “) with a space within them in order to separate your entries with a space. Skip this step if you do not wish to do so.

Step 5: Enter the second cell you want to combine and close the parentheses. Instead of picking another cell, you can also type any text you wish to combine with the first cell.

Enter the second cell you want to combine and close the parentheses.

Step 6: Hit Enter. Your two selected cells will be merged.

Hit Enter. Your two selected cells will be merged. Combine Two Columns in Microsoft Excel

Once you’ve combined two cells, you can combine the two respective columns simply by double-clicking the bottom right corner of the filled cell. You can also left-click the bottom right corner and drag it down to populate the entire column.

Read Also: Microsoft Excel for iPhone can now click photos of spreadsheets

Apart from merging two columns, there are a lot of other tips and tricks that you can use to simplify your task. Excel can even recognize patterns of data on your spreadsheet and autofill it for you using ‘Flash Fill’. On top of that, you can use basic math functions to carry out calculations between individual cells, or even entire columns. 

For the latest gadget and tech news, and gadget reviews, follow us on TwitterFacebook and Instagram. For newest tech & gadget videos subscribe to our YouTube Channel. You can also stay up to date using the Gadget Bridge Android App.

- Advertisement -

Support Us

We are a humble media site trying to survive! As you know we are not placing any article, even the feature stories behind any paywall or subscription model. Help us stay afloat, support with whatever you can!

- Advertisement -

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement -
- Advertisement -
- Advertisement -

Follow Us

- Advertisement -

Must Read

Redmi K50i 5G India launch confirmed to take place on July 20

Redmi K50i 5G India launch confirmed to take place on July...

0
The Redmi K50i 5G launch has been scheduled for July 20 in India. Besides confirming the India launch date, the company has not yet...
- Advertisement -
- Advertisement -
- Advertisement -