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.
Step 2: Type ‘=’ and select the first cell you wish to combine.
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.
Step 5: 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.
Step 2: Type =CONCAT(
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.
Step 6: Hit Enter. Your two selected cells will be merged.
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 Twitter, Facebook 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.
