With Cell Cleaner add-in for Excel you can quickly clean your data imported from an external source.
It will help you remove leading and trailing spaces, excess spaces between words, non-breaking spaces, line breaks, non-printing characters and other unwanted symbols. You can also convert words to a proper case: UPPER, lower or or Proper Case; change numbers stored as text to number format and delete apostrophes.
The add-in works with Microsoft Excel 2013 32-bit and 64-bit, 2010, 2007, 2003.
For more information please visit www.ablebits.com
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... ...