Text to Columns: The Best Organizational Tool to optimize your productivity

Text to Columns: The Best Organizational Tool to optimize your productivity

August 17, 2020

Boss: I need Football data sorted in excel Right Now

gif1-1

You: (Trying to do this last minute) Find the data online and thinking a simple Ctrl+C&V would do the job.

aaa aaa
...
...
...
aaa

If only there is a function allows us to breakdown those data from one cell to a well-sorted excel table.

1

WPS Office Spreadsheets offers you a Text to Columns function. This function is to separate the contents of one spreadsheets cell into separate columns. This function can only be done if there is a character, like comma, space, or other characters

2

To utilize the function 'Text to Columns', the first step is to make observations.
Is there any pattern you find among this one-piece text that can break them into multiple columns? In another word, what is the one unique trait shared in between every interval that you wish to split?
Take the following image as an example➡️

aaa


Even with this chaos layout, it's pretty clear that every text that originally belongs to an indivudual columns is disjoined by a Space! 👇

aaa


Now we just have to hand over the job to Excel by entering this pattern to make this happen!

5
2-1
Screen-Shot-2020-08-17-at-11.13.39-AM
Screen-Shot-2020-08-17-at-11.13.50-AM
Screen-Shot-2020-08-17-at-11.14.01-AM

aaa

aaa

2-3

You can also use this feature on mobile!


Wondering what you could do with WPS Office spreadsheet on your phone? The answer is EVERYTHING!

Now that you've watched the previous tutorial on how to breakdown data from one cell to well-sorted excel table on pc, here comes the mobile version 👇

aaa

2-2

2-2
12-2

*Thank you for staying with WPS Office. Hope to see you next time! *

About Author

International operations department for WPS Office.