Tip of the Day | Monday August 18th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Remove or Replace Unwanted Characters...

This tool removes or replaces unwanted characters from the values in your selected cells.
You can choose from a wide range of characters, including:

Letters (a-z, A-Z)

Numbers (0-9)

Accented letters (ä, é, ü, etc.)

Punctuation and symbols (!, %, @, etc.)

Spaces (standard and nonbreaking)

Line breaks (Alt+Enter line feed and carriage return)

Invisible characters

You can:

Remove the selected characters or replace them with something else.

Target constants, formulas, or both.

Quickly toggle character groups with buttons like a-z, A-Z, 0-9, Symbols, Spaces, Invisible, and Line breaks.

Use the “Invert” option to keep only certain characters and remove the rest.

Use special codes like {lf}, {cr}, {tab} to insert line feeds, carriage returns, or tabs in the replacement value.

Examples of use:

Clean up imported data with invisible or special characters.

Remove all line breaks from your cells.

Keep only numbers or letters and remove everything else.

Replace nonbreaking spaces with regular ones.

Your last used settings are remembered automatically.

Example screenshot: Remove or replace certain characters in selected cells in Excel

Example screenshot: Remove or replace certain characters

Click ASAP Utilities › Text › 14. Remove or Replace Unwanted Characters...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.