How to Use WPS Split Columns on iOS

Use Split Columns with 3 how-to topics, including splitting by delimiter, avoiding overwriting existing data, and finding the entry from the floating menu; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Split by delimiter

Feature entry: Tools → Data → Split Columns

1. Select the cell or range that you want to split.
2. Tap Tools at the bottom of the screen, then open the Data tab.
3. Tap Split Columns.
4. Select a delimiter such as a comma, space, semicolon, or plus sign.
5. Review the result and confirm that the separated values appear in columns to the right.

Success Criteria

• Interface result: the original text is separated into multiple columns.
• Next action available: you can continue editing, undo the change, or save the spreadsheet.

Tips While Using

• Common mistake: if you do not select the target cell or range first, the result may not match your expectation.
• Environment note: keep the target area on the right as blank as possible so the result is easy to review.

2. Avoid overwriting existing data

Feature entry: check the target area before running Split Columns

1. Before splitting, check whether there is already data in the columns to the right of the selected range.
2. If there is existing content, insert blank columns first or move the data to a blank area.
3. Then run Tools → Data → Split Columns.
4. If an overwrite warning appears, cancel the action, adjust the target area, and try again.

Success Criteria

• Interface result: the split result is written into blank columns and important existing data remains unchanged.
• Next action available: you can continue reviewing the result and save the file.

Tips While Using

• Common mistake: ignoring existing content on the right and overwriting original data.
• Environment note: test the split in a blank area first if you are unsure about the result.

3. Find Split Columns from the floating menu

Feature entry: the floating menu after selecting a cell or range

1. Tap the cell or range that you want to split.
2. Check the floating menu on the screen.
3. Find the Split Columns option and open it.
4. Choose the appropriate delimiter and complete the split.

Success Criteria

• Interface result: you can open the Split Columns command from the floating menu.
• Next action available: after the split, you can continue editing the spreadsheet.

Tips While Using

• Common mistake: if no cell is selected first, the related option may not appear in the floating menu.