How to Use WPS Split Columns on macOS

Use Split Columns with 3 how-to topics, including Basic Split Columns, Advanced Split Columns from the Data tab, and Advanced Split Columns from Smart Toolbox; 1 item is available without membership and 2 items are membership-related.

How-to Index

How-to Guide

1. Basic Split Columns

Entry: Data → 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. Select Delimiter or Fixed Width as needed to complete the split.

Success Criteria

• Interface result: the original single-column content is split into adjacent columns.
• Next action available: you can continue editing, formatting, or saving the split data.

Tips While Using

• Common mistake: if the target area already contains data, the split result may overwrite it.
• Environment note: make sure there are enough blank columns on the right side.

2. Advanced Split Columns from the Data Tab

Entry: Data → Split Columns dropdown → Advanced Split Columns

1. Select the data column that you want to split.
2. Click the Data tab.
3. Click the dropdown menu below Split Columns.
4. Click Advanced Split Columns.
5. Choose a split method.
6. Select Fixed Characters, Specific Content, or Character Type as needed to complete the split.

Success Criteria

• Interface result: the data is split into multiple columns based on the selected advanced rule.
• Next action available: you can review the result and adjust the column content.

Tips While Using

• Common mistake: if you do not select the target column first, the split may not run as expected.
• Membership: this topic requires WPS Premium.
• Environment note: for complex text, it is helpful to keep a copy of the original data first.

3. Advanced Split Columns from Smart Toolbox

Entry: Membership Exclusive → Smart Toolbox → Smart Toolbox tab → Advanced Split Columns

1. Select the data column that you want to split.
2. Open the Membership Exclusive tab.
3. Click Smart Toolbox.
4. In the Smart Toolbox tab that opens, click Advanced Split Columns.
5. Choose a split method.
6. Select Fixed Characters, Specific Content, or Character Type as needed to complete the split.

Success Criteria

• Interface result: Advanced Split Columns in Smart Toolbox outputs the split result successfully.
• Next action available: you can continue processing other columns or save the file.

Tips While Using

• Common mistake: if you are not signed in with a membership account, the related entry may be unavailable.
• Membership: this topic requires WPS Premium.
• Environment note: a stable network connection is recommended for membership-related actions.