Removing unwanted characters in Excel

How to remove special characters in Excel 2013-2003

Remove hidden characters from Excel cells

When you download a large database into Excel there can be thousands of unwanted characters to be removed like carriage returns or non-printing characters. Cell Cleaner for Excel will go through your list and delete all unwanted characters according to the settings you select.

Free Download
Free 15-day trial version, 2/25/2014
  1. Expand the Remove unwanted characters section by clicking on the arrows next to the second tab on the Cell Cleaner pane in Excel. To remove characters select the range with the cells that contain values you want to delete.
    Open Remove unwanted characters section by clicking on the arrows
  2. Choose the option that suits your task. You can select one of these five options:
    • Remove non-printing characters - delete all non-printing characters like line breaks, the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) and additional nonprinting characters (values 127, 129, 141, 143, 144, and 157); Select this option to remove line breaks and non-printing characters
    • Remove numeric characters - delete all digits from the selected cells Select this option to delete digits from the cells
    • Remove text characters - delete all letters from your cells; Select this option to delete letters from the cells
    • Remove symbols and punctuation marks - this option removes all punctuation marks in the selected range as well as the following symbols: mathematical, geometric, technical and currency symbols, letterlike symbols such as ?,¹, and ™. Select this option to delete special symbols and punctuation marks
    • Remove custom characters - This option will remove special characters in Excel. If you have several characters that you need to delete from your range and you don't want to repeat this routine operation several times, just enter each character you need to delete into Remove custom characters field.
      Select this option to change case of the text in the range
  3. Click the Run button to enjoy quick results.

Thus you can clean your data in Excel and remove all kinds of symbols - from unwanted or forbidden characters to non-printing characters and line breaks.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
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
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
Awesome!!!
Sheila Blanchard