When using Split Columns, the most common questions fall into 3 areas: overwritten data, collaboration sync, and unexpected split results; this section includes 3 common answers.
FAQ
What should I do if data on the right is overwritten after Split Columns?
- Check whether the destination range was set to an area that already contained data.
- If you just completed the action, use Undo immediately to restore the original content.
- Before running Split Columns again, leave blank columns or choose a different destination range.
Will Split Columns affect other collaborators in collaboration mode?
- Yes. The split result directly changes the current sheet data.
- If the sheet is shared, the updated content syncs to other collaborators.
- It is recommended to confirm with the team first, or complete the cleanup in a copy before pasting the result back.
Why does the split result not match what I expected?
- Check whether the selected delimiter is correct, such as comma, space, or a custom character.
- Review whether you need to treat consecutive delimiters as one.
- Use the preview area to confirm the result before clicking Finish.
Glossary
| Term | Definition |
|---|---|
| Delimiter | A character used to split text content, such as a comma, space, semicolon, or custom symbol. |
| Destination range | The starting cell location where the split result is written in the worksheet. |
| Column data type | The data format applied to each split column, such as General, Text, Date, or Skip import. |