Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

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

Walter Hickey,Daniel GoodmanJul 6, 2013, 00:30 IST

Your browser doesn't support HTML5 video.

While Microsoft Excel is an impeccable program, sometimes you're forced to scrounge for data from less organized places.

Here, we look at one such example where the data that we import is all stuck in the same cell.

The process that we use to fix it - using the LEFT, RIGHT and LEN formulas - save hours of manual copy and paste labor. Check it out:

kalturavideoplaceholder

Produced by Daniel Goodman