How to split columns in a sheet

September 28, 2021
997 Views 0

Graphic skills

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'

How to split columns 素材.gif



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