logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Remove or Replace Unwanted Characters...

ASAP Utilities  › Text  ›  14. 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.

    Screenshots

    Example screenshot: Remove or replace certain characters in selected cells in Excel
    Remove or replace certain characters in selected cells in Excel
    Example screenshot: Remove or replace certain characters
    Remove or replace certain characters
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Text  ›  14 Remove or Replace Unwanted Characters...
    Additional keywords for this tool:
    Remove unwanted characters in Excel, Delete special characters from cells, Remove line breaks and carriage returns, Replace characters in cell values, Clean invisible characters, Strip symbols and punctuation, Remove CR LF line breaks, Find and remove non-printable characters, Remove nonbreaking spaces, Clean up messy imported text, Delete alphabet letters from cells, Remove tabs, returns, and special characters, Keep only numbers or letters, Remove all but numbers, Character cleanup tool, Delete hidden characters, Remove all text except digits, Replace line feed with space, Advanced character replace, Remove or replace control characters



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


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