In the Excel worksheet where you want to combine two columns of data, first insert a new column near the ... "Separator", ...

There are two other methods to use the Column function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear. Inside the dialog ...