WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


More features in Splitting Columns

Uploaded time: December 24, 2021 Difficulty Beginner

More features in Splitting Columns

More features in Splitting Columns

When several pieces of information are filled in one cell, we often need to split it into multiple columns, and both WPS Spreadsheets and Microsoft Excel support splitting columns.

Take this table as an example.

In Microsoft Excel, we select the cell range of A2:A11, click the Data tab, click Text to Columns, and we can choose Delimited or Text Widthto split columns manually.

In addition to this original method, WPS Spreadsheets has a new feature, namely, Smart Split Columns. It has two outstanding advantages.

· Splitting columns intelligently

The content of the table can be identified intelligently and split into columns quickly, and no manual operation is needed.

Take this table as an example.

1. We select the cell range of A2:A11, and in the Text to Columns drop-down button, click Smart Split Columns. Then we can preview it in the preview window in real time.

2. If we are not satisfied with the result, click to add or delete the dividing lines.

3. Lastly, click Finish for the output.

· Multiple splitting methods for selection

1. If the automatic identification is unsatisfying, we can click Manually Split Columns at the bottom for further adjustment.

WPS Office provides more methods for splitting, namely, Delimiter, Text Type, By Keyword, and Fixed Width.

In the Text Type worksheet, it's observed that the content is made up of English words and numbers to split columns according to that.

2. Select Text Type, check Number, and English, and we can preview the table that is split into numbers columns and English words columns.

3. Then click Finish.

Then, let's look at the By Keyword worksheet. There are no numbers or separators in this table, so how can we split it?

1. In this table, since all the text contains the word College, we can choose By Keyword here.

2. Input C in the Use the following keywords to split text area, and check Before keyword to separate out the word College.

3. Then click Finish.

If we have a uniform format for regular table data, such as data, badge numbers, and phone numbers, we can choose Fixed Width.We can click the position in the table to be split to generate a dividing line. Then click Finish.

These are the convenient methods for splitting columns intelligently to satisfy your needs in different scenarios.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.