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 *

Check Also

The Tiny Monorails That Once Carried James Bond / Tom Scott

The Roadmachines Mono-Rail may have been the only ...

Photos from Flickr