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.