How to split columns in a sheet

September 28, 2021
9.6K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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.