Removing unwanted characters in Excel

How to remove special characters in Excel 2016, 2013-2007

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, 15.66 MB

Remove unwanted characters from your cells

  1. Run the Remove Characters tool by clicking on its icon under the Ablebits Data tab 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 Remove 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.

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
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