How to split columns in a sheet

1. Select the target range in WPS Spreadsheet.

2. Click Data → Text to Columns

3. Choose Delimited in the interface of 'Convert Text to Columns Wizard - Step 1 of 3'

4. In the interface of 'Convert Text to Columns Wizard - Step 2 of 3', select the delimiters in terms of your demands.

5. Click Finish in the interface of 'Convert Text to Columns Wizard - Step 2 of 3'. 

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.