Instead, you need to use the CONCATENATE formula to combine that data. In the Excel worksheet where you want to combine two columns of data, first insert a new column near the data you want to ...