close
close

How to combine two columns in Microsoft Excel?

If you’re just starting to use Microsoft Excel, there are a variety of features that you may not be familiar with. These features are super easy to use and will make your Excel experience a lot easier. You can use one of these functions to combine the data in two cells. This saves you the trouble 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.

Also read: How to create a checklist in Excel

– Advertisement –

Table of Contents

Using the ampersand symbol (&) to combine two columns in Microsoft Excel

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

– Advertisement –

Select the cell where you want to place the combined data.  Combine two columns in Microsoft Excel

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

– Advertisement –

Step 3: Type “&” followed by quotation marks (” “) with a space between them. This is done to separate your data entries with a space. If you don’t want a space between your wholes, skip the quotes.

Step 4: Select the other cell that you want to combine. For example, if you combine the data from A3 and B3 cells, your formula should look like this: =A3&” “B3.

Select the other cell that 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 where you want to place the combined data.

Select the cell where 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: Put two quotation marks (“ ”) with a space between them to separate your entries with a space. Skip this step if you don’t want to.

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

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

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

Press Enter.  Your two selected cells will be merged.  Combine two columns in Microsoft Excel

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

Also read: Microsoft Excel for iPhone can now click spreadsheet photos

Aside from merging two columns, there are many other tips and tricks you can use to simplify your task. Excel can even recognize data patterns in your spreadsheet and automatically fill them in for you using Flash Fill. In addition, you can use simple mathematical functions to perform calculations between individual cells or even entire columns.

For the latest gadget and tech news and gadget reviews, follow us Twitter, Facebook and Instagram. Subscribe to our YouTube channel for the latest tech and gadget videos. You can also stay connected with the Gadget Bridge Android app.

– Advertisement –

Leave a Comment