1. Select the data that needs to be split, separate the data that needs to be split between spaces or other symbols, and click the "data" → "columns" of the toolbar.
2. Then enter the text Breakdown wizard settings, according to the system to operate.
3. The separator can be checked according to the contents of our cell.
4. Then you will enter the split preview page to confirm the correct click complete.
5. So we will find that the data has been successfully split, is not very convenient?