With this add-in for Microsoft Excel you can quickly clean data imported from an external date source and get it to the format convenient for further analysis. The Cell Cleaner for Excel automates such tasks as removing excess spaces, converting numbers stored as text to number format and changing Excel text case.
In just a couple of clicks you can:
Remove leading and trailing spaces in your spreaders.
Convert all words in selected cells to a proper case: UPPER, lower or Proper Case.
Change numbers stored as text to number format.
Delete redundant apostrophes.
Eliminate excess spaces between words and wipe out nonbreaking spaces ( ).
Delete line breaks, non-printing characters, punctuation marks and other unwanted symbols
The add-in works with Microsoft Excel 2010 32-bit and 64-bit, 2007, 2003.
ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...