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