25. Excel How to split a column of text into several columns ? How to split a cell ?

Consider the list of cities with the regions to which they belong.

We want to separate the cities from the regions in two columns:

Excel 2016 Example Splitting a column of text

1 - Select column B.

2 - Click the Text to Columns button in the Data Tools group of the Data tab of the Ribbon.

Excel 2016 Text to Columns button

This starts the Convert Text to Columns Wizard.

3 - In step 1 of the wizard, leave the Delimited option selected. Click on the Next button.

4 - In step 2, uncheck the Tab box, check the Other box and enter the character "/" in the text field. The effect is shown immediately in the Data preview at the bottom. You can immediately click on the Finish button.

Excel 2016 Convert Text to Columns Wizard

<< 24. Excel How to delete every other row ?

26. Excel How to Delete Filtered Rows ? >>