Cell Cleaner for Microsoft Excel - cleaning hero for your worksheets

In this article you will learn about Cell Cleaner for Excel by Ablebits and its new options

Cell Cleaner heroYou've imported data to Microsoft Excel from the web and realized the entire nightmare of the next couple of hours.  You simply can't work with the table because numbers are stored as text, words have the wrong case, strange characters are hanging around your cells... And on the whole the database that was initially supposed to help you is a complete chaos.

Cell Cleaner is the add-in for Microsoft Excel that will automate trimming spaces, changing number format and case. It also offers brand new features that allow removing or replacing unwanted characters and symbols.

Save your table from unwanted characters

If you have irrelevant symbols and characters scattered around your worksheet and cluttering up the cells this cleaning hero of an add-in has the Remove unwanted characters tab. Declutter your workbook by deleting inappropriate non-printing, numeric and text characters. You can also choose to wipe out special symbols like @%& and punctuation marks. If it's not enough, enter any custom character you need to remove in the corresponding field.

Trim excess spaces away

Remove unwanted characters in ExcelWhen you copy data from a text file or web page for example, it can result in numerous extra blanks in your spreadsheet.  Excess spaces can lead to inability to remove duplicate values as well as to annoying layout.  Cell Cleaner has the Trim spaces section where you can choose to:

  • delete leading and trailing spaces which appear before and after cell values,
  • trim blanks between cell values to one
  • and get rid of   which get to your table as part of HTML code especially if you happen to download data from the web.

Change number format and convert text

If you see that a formula doesn't work, the reason can be the fact that the digits are stored as text.  You can convert them back to number format in a click. One more new feature is the possibility to replace characters and line breaks with a different character.

Just in case the case is wrong

One more solution Cell Cleaner offers to you is changing text case in Excel. You can convert the words to upper or lower case, capitalize each word or cell in the selected range.

It's that easy! No more need to work for your table before it starts working for you. With Cell Cleaner for Excel and its new options your table will be as clean as a whistle.

Give it a try!

Feel free to download a fully-functional 30-day evaluation version of the Cell Cleaner add-in.

4 Responses to "Cell Cleaner for Microsoft Excel - cleaning hero for your worksheets"

  1. Muhammad Kamran Zahid says:

    I downloaded this and installed this. But now I can't uninstall this. How can I remove this from my PC

  2. Muhammad Kamran Zahid says:

    it also don't work by the way.

Post a comment

Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard