How to Process data with Text to Columns

Key Points Catalogue

The key points of this lesson

In this lesson, we've learned the rules for Smart Split Columns:

1. In dealing with table data, we often need to split the contents of the cell. There is a good function for it in WPS Spreadsheet, that is Smart split Columns.Select the needed area, click the Data> Text to columns> Smart Split Columns.Only taking 1 second, you can preview the result of the system's intelligent splitting in the pop-up dialog box.

Of course, you can manually select different splitting methods, such as Delimiter, Text Type, By keyword, and Fixed Width.

2. In addition to splitting, it can help you standardize data formats. For example, numerical dates can be converted into standardized formats, and number formats can be converted into text formats.

PS: Through the ampersand & and Ctrl + E (Flash fill), you can re-merge the split data.

You'll Learn

The basics of WPS Spreadsheet.

The most commonly-used batch processing skills for increasing productivity.

Process large data in WPS Spreadsheet.

Master the popular PivotTables to create dynamic reports.

Nest dynamic formulas, including the IF, VLOOKUP, SUMIF, and MATCH functions to impress your leader.

Acquire skills in improving security, sharing, co-editing, and printing files.

Course Content

Start from beginners, from theory to practice, don't worry about learning

You'll Get

300+ Mins Videos
100+ Real Cases
40+ Practice Files

Comments

Marry Li HR

Seriously, it really helped me a lot. I used to be overwhelmed by the huge amount of data every day, but the spreadsheet has relieved me of the statistical burden!

Rose J Teacther

WPS Office is completely beyond imagination and now I am highly dependent on it for my work, creating test papers, courseware, and slideshows ...... It covers almost everything.

Catalogue