Ablebits.com Cell Cleaner for Excel

With this nifty add-in 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 Excel 2003-2010.