In the Excel worksheet where you want to combine two columns of data, first insert a new column near the data you want to combine. This is where your combined data will be displayed.

You can combine text from multiple cells into one cell in Excel using the Ampersand symbol (&) or by using the CONCATENATE function.