How to Use WPS Split Columns on Windows

This how-to guide includes 3 topics: opening the Split Columns wizard, setting delimiters, and setting column data types and the destination range; choose a topic from the index and follow the steps to finish the task.

How-to Index

How-to Guide

1. Open the Split Columns wizard

Entry: Data tab → Split Columns

1. Select the column data that you want to split.
2. Check that there are enough blank columns to the right for the output.
3. Click Split Columns on the Data tab.
4. Wait for the Split Columns dialog box to open.

Success Criteria

• Interface result: the Split Columns dialog box is open.
• Next action available: you can continue to set delimiters, column types, and the destination range.

Tips While Using

• Common mistake: if you do not leave blank columns, the result may overwrite data on the right.
• Environment note: select the target data column before opening the feature.

2. Set delimiters and preview the result

Entry: Split Columns dialog box → delimiter selection area

1. In the delimiter area, select the delimiter used in your source text.
2. If the text uses a custom character, select Other and enter that delimiter.
3. To avoid extra blank columns, enable Treat consecutive delimiters as one.
4. Check the preview area to confirm the split result.
5. Click Next to continue, or click Finish directly if the current setup is already correct.

Success Criteria

• Interface result: the preview area shows the split result based on the selected delimiter.
• Next action available: you can continue to set the data type for each column and the output location.

Tips While Using

• Common mistake: choosing the wrong delimiter can create too many columns or incomplete field splits.
• Environment note: more consistent source delimiters usually produce more stable results.

3. Set column data types and the destination range

Entry: Split Columns dialog box → data preview / column data type / destination range

1. In the Data Preview area, click a column that you want to format separately.
2. In Column Data Type, choose General, Text, Date, or Do not import column (Skip).
3. In the Destination box, confirm or change the output location.
4. If you need to revise the delimiter settings, click Back.
5. Click Finish to run Split Columns.

Success Criteria

• Interface result: the split result appears in the destination range.
• Next action available: you can continue editing, saving, filtering, or sorting the result columns.
• No unwanted side effect: existing data remains unchanged if it is outside the destination area.

Tips While Using

• Common mistake: an incorrect destination range can overwrite existing content.
• Environment note: choose the correct date order when converting date columns.