Ablebits.com Cell Cleaner for Excel
Ablebits.com Cell Cleaner for Excel Description:
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 plug-in 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.
For more information please visit http://www.ablebits.com
System Requirements: Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, 2003
Operating System Support: WinXP, WinVista, WinVista x64, Win7 x32, Win7 x64, Windows2000, Windows2003, WinServer, Windows Vista Ultimate, Windows Vista Ultimate x64, Windows Vista Starter, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Business, Windows Vista Enterprise, Windows Vista Home Basic x64, Windows Vista Home Premium x64, Windows Vista Business x64, Windows Vista Enterprise x64
Tags: excel, trim space, change case, convert numbers