WPS Split Columns on macOS FAQ

Last updated:July 20, 2026

Common questions about Split Columns usually involve overwritten data, changed formats, and unexpected blank columns; this FAQ covers 3 frequent questions and a short glossary.

FAQ

What should I do if data on the right is overwritten after using Split Columns?

  1. Check whether the destination range was placed next to existing data before you finished the split.
  2. If the action was just completed, press Command+Z immediately to undo it.
  3. Leave enough blank columns or choose a different destination range, then run the split again.

Why did the data format change after splitting columns?

  1. Open the Split Columns workflow again and go to the second-stage settings.
  2. In the column data type area, set the affected column to Text, Date, or General.
  3. After splitting, you can still use cell formatting tools to adjust the final display if needed.

Why do extra blank columns appear after splitting text?

  1. Check whether the original data contains repeated delimiters.
  2. Turn on the option that treats consecutive delimiters as one.
  3. Review the preview again and confirm that the number of blank columns is reduced before finishing.

Glossary

TermDefinition
DelimiterA character used to mark where text should be split, such as a comma, semicolon, space, or custom symbol.
Destination rangeThe location where the split result will be written, starting from a selected cell.
Column data typeThe format assigned to each output column after splitting, such as General, Text, Date, or Skip.