Cell Cleaner for Microsoft Excel

How to delete excess spaces in your Excel tables

Occasionally, extra spaces prevent some add-ins or functions from working correctly. Blanks before and after cell values, additional spaces between the words in your cells may be 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.

More about trimming excess spaces.

Delete unwanted characters from the entire range

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.

More about removing unwanted charachters from Excel cells.

Convert text and change case in Excel

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. More about changing number format, replacing irrelevant characters and line breaks.

Cell Cleaner also 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. More about converting Excel text case.

With Cell Cleaner you can

1. Delete leading and trailing spaces
2. Remove spaces between words to 1 and wipe out " "
3. Remove unwanted non-printing, numeric, text or custom characters from your cells
4. Convert all words within selected cells to upper,lower case or capitalize each cell or word
5. Convert number stored as text to number format
6. Replace line breaks with spaces
7. Replace or remove several individual characters in one go

Cell Cleaner for Excel screenshots

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

Remove special characters, non-printing symbols etc.

Clean cells of all unwanted characters in a click

Convert numbers stored as text to number format, replace line breaks

Converting text to numbers will make calculations easier

Change case in Excel cells to UPPER, lower, Proper, or capitalized

Cell Cleaner for Excel system requirements:

Operating System

• Windows 8 (32- and 64-bit)
• Windows 7 (32- and 64-bit)
• Windows Vista (32- and 64-bit)
• Windows XP (32-bit)
• Windows Server 2003, 2008, 2012
• .NET Framework 2.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Microsoft Excel

• Microsoft Excel 2013 (32- and 64-bit)
• Microsoft Excel 2010 (32- and 64-bit)
• Microsoft Excel 2007
• Microsoft Excel 2003

Cell Cleaner version

Current add-in version: 2.3.6
published on: Oct 02, 2014

End-User License Agreement (EULA).