You can combine two columns in Excel using several formulas and tools available in the software. If the columns that you want to combine are empty, you can use Excel's merge function.

Combine 2 Cells in Excel With CONCAT The CONCAT function gives you the ability to combine the contents from one or more cells with any additional text you want.

You can merge and combine multiple cells or columns without losing data in Excel and create customized lists, by following any one of these methods.

Let’s take a look at how to use concatenate in Excel. Using the concatenate function for two columns in Excel Step 1: Select the column and cell in which you’ll be combining data from other cells.