When you import data from an external source such as a database, text file, or a web page, you don't always have control over the format. Unwanted spaces, improper cases and wrong formatting create a real mess and complicate data analysis. Cell Cleaner will help you clean it up!
Right case and format, no extra spaces!
With this nifty add-in you can quickly get your data exactly the way you want it:
- Remove leading and trailing spaces in your worksheets
- Convert all words in selected cells to a proper case: UPPER, lower or Proper Case
- Delete line breaks, non-printing characters, punctuation marks and other unwanted symbols
- Change numbers stored as text to number format and delete apostrophes
- Eliminate excess spaces between words and wipe out non-breaking spaces ( )