Microsoft Excel – Repair numbers formatted as text

The Microsoft Office Blog details how a combination of the TRIM, CLEAN and Convert to Number functions in Excel can take numbers that are surrounded by extraneous data and make them usable again. Getting badly-formatted spreadsheets isn’t uncommon, so it’s good to know about these options even if you’ll still need to double-check the results afterwards — via lifehacker

Share this Story
Load More Related Articles
Load More By Red Wolf
Load More In Technology

Leave a Reply

Your email address will not be published. Required fields are marked *

Photos from Flickr