Cell Cleaner for Microsoft^® Excel^®

Delete spaces and characters, change case, convert number format in Excel

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Delete excess spaces or other
unwanted characters and change
format or case of cell values

When you copy data from a web page or a text file to Microsoft Excel, it can have extra spaces or unwanted formatting. There may be numbers stored as text, excess spaces and characters or words written in a wrong case. You may not notice that you need to clean your data in Excel until you have to process it further.

With Cell Cleaner you can do it all:

• Delete leading and trailing spaces
• Remove spaces between words to 1
• Wipe out " "
• Remove unwanted non-printing, numeric, text or custom characters from your cells
• Convert all words within selected cells to upper or lower case
• Capitalize each cell or word in your cells
• Convert number in text format to number format
• Replace line breaks with spaces
• Replace or remove several individual characters in one go

How to delete excess spaces in your Excel tables

Remove leading and trailing spaces,
trim blanks between words to one

Occasionally, extra spaces can prevent some add-ins or functions from working correctly. Blanks before and after cell values, some additional spaces between the words in your cells may cause a problem when you filter, match or merge tables. You can polish up your data by deleting all unwanted spaces in one go. The Cell Cleaner for Microsoft Excel add-in will quickly remove leading and trailing spaces, trim spaces between words to one and delete non-breaking spaces ('&nbsp') from your worksheets.

Delete unwanted characters from the entire range

Delete non-printing, numeric, text,
special or custom characters

Your spreadsheet can contain irrelevant characters you used to remove one by one. The Cell Cleaner plug-in automates such tasks. Wipe out all non-printing characters like line breaks, delete all digits, letters or special mathematical, currency and letter like symbols and punctuation marks. Or just use the custom characters box and enter whichever values you need to remove.

Convert text

Convert digits stored as text to
number format,replace line breaks
or other characters

When copying numerical data to Excel, you can get it stored as text. You can also indicate that digits must be treated as text yourself if you use the apostrophe before them. Both options can cause problems with calculations or result in irregular sorting. With this nifty add-in you can quickly convert the digits back to number format and delete spaces and apostrophes at the same time.

If you have several characters here and there in your table that you need to replace with a different one, use the Convert characters option instead of repeating the same find-and-replace steps. It will substitute all the characters you enter individually.

Extra line breaks is another common problem that the add-in solves, you can simply replace them with spaces or any other characters.

Change case in Excel

Change all words within your range
to upper, lower or proper case
or capitalize each cell

Cell Cleaner offers an easy possibility to convert case in the selected cells. Just choose to convert to upper or lower case, to capitalize each cell or use proper case in the range you select and click Run.

How to clean your Excel data in 2 clicks:

1. Select the values you want to correct;
2. Click the Cell Cleaner icon and tweak the appropriate settings;
3. Click Run and enjoy perfectly clean data in Excel!

Download now and see how it can help you