WPS Split Columns on Windows FAQ

Last updated:July 20, 2026

Common questions about WPS Split Columns usually involve overwritten data, changed formats, and unexpected split results; this FAQ covers 4 frequent questions and a glossary of key terms.

FAQ

What should I do if Split Columns overwrites data on the right?

  1. Press Ctrl+Z to undo the split operation immediately.
  2. Select the original source column again and check whether enough blank columns are available on the right.
  3. Set a new blank destination cell or range before running the split again.

Why do my dates or IDs look wrong after splitting text into columns?

  1. Open the Split Columns workflow again.
  2. In the second stage, select the affected output column.
  3. Change the column data type to Text or choose the correct Date format before finishing.

Why does Split Columns create extra blank columns?

  1. Check whether the source text contains repeated spaces or repeated delimiters.
  2. Turn on Treat consecutive delimiters as one in the split settings.
  3. Review the preview again to confirm that the extra blank columns are reduced.

How do I keep only the columns I need and skip the others?

  1. In the preview area, click the column that you do not want to import.
  2. In Column Data Type, choose Do not import column (Skip).
  3. Finish the split so that only the needed columns remain.

Glossary

TermDefinition
DelimiterA character used to split text, such as a comma, semicolon, space, or custom symbol.
Destination rangeThe location where the split result is written, usually starting from a selected cell.
Column data typeThe format applied to each output column, such as General, Text, Date, or Skip Import.
Treat consecutive delimiters as oneAn option that handles repeated delimiters as a single split point to reduce extra blank columns.