These FAQs cover 3 common question types about Split Columns on Android, including overwritten results, undo steps, and where to find the entry.
FAQ
Will Split Columns affect my original data?
- The split result is placed in the columns to the right of the original data by default.
- If those columns already contain content, check them first and leave blank columns before you run the feature.
- Review the result after splitting to make sure important data was not overwritten.
How do I undo Split Columns?
- Tap Undo right after you complete the split.
- If you have already made other edits, confirm that the undo order still points to the split action.
- After undoing, select the range and delimiter again, then run Split Columns one more time.
Why can’t I find the Split Columns entry?
- Make sure you are working in a spreadsheet file rather than a Writer or Presentation file.
- Select a cell or range, tap Tools, and switch to the Data tab.
- If the entry still does not appear, update WPS Office and reopen the file to check again.
Glossary
| Term | Definition |
|---|---|
| Split Columns | An action that splits the text in one cell into multiple columns based on a selected delimiter. |
| Delimiter | A character used to split text, such as a comma, space, semicolon, or plus sign. |
| Output area | The location where the split result is written, usually to the right of the original data. |