How to split columns in a sheet
A free Office suite fully compatible with Microsoft Office
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.
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Check if value is in list in Excel (3 easy methods)