Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
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.
Also Read:
- 1. How to Split name into two columns in excel (3 Easy ways)
- 2. How to Change Sheet Name in Excel Sheet with Shortcut
- 3. How to split PDF file into multiple pages quickly in WPS Office
- 4. How to split and wrap text into different columns in excel
- 5. Collapse or expand rows or columns in a sheet
- 6. How to split text into two columns in WPS Writer
15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.
