Let us follow the same procedure, but this time there are three texts, so we will insert two columns instead of one. I want all three texts in a separate column. I have the following data with me where in Column B, three texts are separated together with a hyphen (-). I want the data in the same format so we can click finish to see the result.
When we click on next, the dialog box appears, which allows us to change the format of both columns.To do so, we double-click on the second line.
So I need to delete the line between the second and third columns. In this example, I want to split the data into two columns, not in three, as the preview shows above.