How to Use WPS Split Columns on macOS

Use Split Columns through 3 how-to topics, including opening the feature, setting delimiters, and setting column types with a destination range.

How-to Index

How-to Guide

1. Open Split Columns

Entry: Data → Split Columns

1. Select the column data that you want to split.
2. Check whether there are enough blank columns to the right to receive the results.
3. Click Split Columns on the Data tab.
4. When the Split Columns dialog opens, continue to the next settings step.

Success Criteria

• Interface result: the Split Columns dialog is open.
• You can continue: delimiter settings are available.
• No side effect: the original selection remains selected.

Tips While Using

• Common mistake: if there are no blank columns on the right, the result may overwrite existing data.
• Environment note: use this feature in an editable worksheet.

2. Set delimiters and preview results

Entry: Split Columns dialog → delimiter selection area

1. In the delimiter area, choose the separator used in your source data.
2. If your data uses Tab, semicolon, comma, or space, select the matching option directly.
3. If your data uses another character, enter it in the Other box.
4. To reduce unnecessary blank columns, enable the option that treats consecutive delimiters as one.
5. Review the split result in the preview area.
6. Click Next to continue, or click Finish directly if the result is already correct.

Success Criteria

• Interface result: the preview area shows the split result based on the selected delimiter.
• You can continue: column type and destination settings are available.
• No side effect: the original data is not written to a new location before you finish.

Tips While Using

• Common mistake: choosing the wrong delimiter can produce the wrong number of columns.
• Environment note: a custom delimiter should match the actual character in the source data.

3. Set column data types and the destination range

Entry: Split Columns dialog → column data type area + destination range box

1. In the data preview area, click a column to set its format individually.
2. In the column data type area, choose General, Text, Date, or Do not import this column (Skip).
3. Confirm or change the output location in the destination range box.
4. If needed, click Previous to go back and adjust delimiter settings.
5. Click Finish to run Split Columns.

Success Criteria

• Interface result: the split result is written to the destination range and displayed with the selected column types.
• You can continue: you can keep editing, formatting, or saving the worksheet.
• No side effect: skipped columns are not imported into the result.

Tips While Using

• Common mistake: an incorrect destination range may overwrite existing data.
• Environment note: for date columns, choose a date arrangement that matches the original content.