These Excel Text Tricks Will Save Your Life When Cleaning Up Disorganized Data

While Microsoft Excel is an impeccable program, sometimes you’re forced to scrounge for data from less organised places. Here, we look at one such example where the data that we import is all stuck in the same cell.

Produced by Daniel Goodman and Walter Hickey. Originally published in July 2013.

NOW WATCH: Tech Insider videos

Want to read a more in-depth view on the trends influencing Australian business and the global economy? BI / Research is designed to help executives and industry leaders understand the major challenges and opportunities for industry, technology, strategy and the economy in the future. Sign up for free at

Tagged In

clusterstock sai-us