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:
1 - Select column B.
2 - Click the Text to Columns button in the Data Tools group of the Data tab of the Ribbon.
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.