More features in Splitting Columns

Uploaded time: December 24, 2021 Difficulty: Primary

More features in Splitting Columns

More features in Splitting Columns

Tips: you can turn on the volume by clicking

Graphic skills

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 Width to split columns manually.

_1.gif

 

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.

_2.gif

 

· 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.

_3.gif

 

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.

_4.gif

 

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.

_5.gif

 

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.

_6.gif

 

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