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.

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

Produced by Daniel Goodman

Business Insider Emails & Alerts

Site highlights each day to your inbox.

Follow Business Insider Australia on Facebook, Twitter, LinkedIn, and Instagram.