Trim spaces, change case, remove unwanted characters

Cell Cleaner for Microsoft Excel 2016, 2013-2003

Task

If you have ever happened to fetch data from an external database into Excel, you know that it often results in numerous excess spaces, irrelevant characters and numbers formatted incorrectly. What you need is to quickly and easily clean up your data in Excel.

Solution

Cell Cleaner for Excel trims spaces, removes or replaces any irrelevant characters, lets you change case, convert text, and much more.

Remove excess spaces, change text case, and reformat numbers in Excel.

Cell Cleaner key features

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

This add-in will polish off your Excel tables and make them ready for further processing. It has all the options you may need to turn your data from a complete chaos to a worksheet that is supposed to help you.

  • Delete leading and trailing blanks, cut spaces between words to 1
  • Remove non-breaking spaces  
  • Get rid of non-printing, numeric, and/or text characters
  • Cut out special symbols and punctuation marks
  • Specify particular characters you want to remove
  • Change case to UPPER, lower, proper, or capitalize each cell
  • Convert numbers stored as text back to number format
  • Replace carriage returns with a character of your choice

Tip

You can get this add-in as a part of Ultimate Suite for Excel - 40+ tools destined to cut your time and clicks on the most frequent spreadsheet tasks.

Cell Cleaner in detail

Remove non-printing symbols, special characters, etc.
Convert numbers stored as text to number format, replace line breaks.
Change case in Excel to UPPER, lower, Proper, or capitalize each cell.

Cell Cleaner is an add-in that deletes and replaces unwanted data as well as converts the wrong case in the entire range. If you regularly work with input files that you need to prepare for further analysis, you know that they often contain inappropriate characters, extra spaces, the wrong case and number format. This tool will help you search and remove, or replace, any irrelevant data. No need to work for your table before it starts working for you. With Cell Cleaner for Excel and all the possibilities it gives, your spreadsheets will be as clean as a whistle.

Cell Cleaner is compatible with all Excel versions from 2003 to 2016 and you can install it on Windows 8/7, Vista, and XP. If you need to install it to Server 2003-2012, it should be no problem at all. Terminal Server setup is available as well.

Delete excess spaces in Excel

It can be really annoying if extra spaces don't let you sort, merge or delete duplicates in your data. Cell Cleaner automatically removes leading and trailing spaces and trims blanks between words to one. If you happen to download data from the web, it will help you get rid of  , which get to your table as part of HTML code.

Remove all kinds of irrelevant characters from your worksheet

If you have unwanted symbols and characters around your worksheet, benefit from the Cell Cleaner Remove unwanted characters group. One click will save your workbook from 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, type any character you need to delete.

Change text case in Excel

Suppose you have the entire table in upper case and need to change it to lower case. Or the full names in your worksheet aren't capitalized. Changing case in your spreadsheet can be a huge pain. Not with Cell Cleaner that helps you to easily convert the words to upper or lower case, capitalize each word or cell in the selected range.

Correct number format and convert text

Digits stored as text can cause issues, for example, if you need to use a formula. Cell Cleaner converts them back to number format in a click.

You can also replace characters and carriage returns with a different symbol, like a space. You can enter the new symbol and all line breaks and other characters of your choice will be overwritten with it.

Cell Cleaner is a real find for those who regularly work with large imported databases that are full of irrelevant data that needs to be removed or replaced.

19.95
Buy now

Cell Cleaner for Microsoft Excel system requirements

Microsoft Excel

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

Operating System

  • Windows 10 (32 and 64-bit)
  • 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 4.0 must be installed.

Cell Cleaner for Excel version

Current add-in version: 3.0.23
published on: Feb 02, 2016

Order Cell Cleaner for Excel

19.95
Buy now
 
Contact us