How to Use WPS Split Columns on Windows

Use Split Columns with 3 how-to topics, including basic splitting, advanced splitting from the Data tab, and advanced splitting from Smart Toolbox; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Use basic Split Columns

Feature entry: Data tab → Split Columns

1. Select the data column that you want to split.
2. Click Split Columns on the Data tab.
3. Choose a split method.
4. Use Delimiter or Fixed Width to complete the split.

Success Criteria

• Interface result: The original content is split into adjacent columns.
• What you can do next: You can continue to filter, sort, or calculate with the split columns.

Tips While Using

• Common mistake: If there is already data in the columns to the right, the split result may overwrite it.
• Environment note: Leave enough empty columns before you start.

2. Use advanced Split Columns from the Data tab

Feature entry: Data tab → Split Columns dropdown menu → Advanced Split Columns

1. Select the data column that you want to split.
2. Click the Data tab.
3. Open the dropdown menu under Split Columns.
4. Click Advanced Split Columns.
5. Choose the advanced split method you need.
6. Use Fixed Characters, Specific Content, or Character Type to complete the split.

Success Criteria

• Interface result: The data is split into multiple columns based on the selected advanced rule.
• What you can do next: You can continue organizing the resulting fields.

Tips While Using

• Common mistake: If you do not select the target data column first, the split may not run as expected.
• Membership note: This topic requires WPS Premium.

3. Use advanced Split Columns from Smart Toolbox

Feature entry: Member Exclusive tab → Smart Toolbox → Smart Toolbox tab → Advanced Split Columns

1. Select the data column that you want to split.
2. Open the Member Exclusive tab.
3. Click Smart Toolbox.
4. In the Smart Toolbox tab that appears, click Advanced Split Columns.
5. Choose the advanced split method you need.
6. Use Fixed Characters, Specific Content, or Character Type to complete the split.

Success Criteria

• Interface result: Advanced Split Columns in Smart Toolbox completes the field split.
• What you can do next: You can continue processing the result in the toolbox or in the spreadsheet.

Tips While Using

• Common mistake: If you do not enter the Smart Toolbox tab, the entry may be hard to find.
• Membership note: This topic requires WPS Premium.