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 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.

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.