logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Advanced Find and Replace...

ASAP Utilities  › Range  ›  1. Advanced Find and Replace...

Easily search and replace text within a selected range, across the entire worksheet, or in all worksheets at once.
This tool provides enhanced functionality compared to Excel's standard Find and Replace features. Search results are displayed in a list, allowing you to jump directly to a cell. You can replace matches one by one or replace them all at once. Key advantages over Excel's default Find and Replace:
  • Match entire words or phrases only, avoiding unintended partial replacements (e.g., replacing Lake without affecting Lakeland or Blake)
  • Find and replace long text values in Excel without encountering the 'Formula is too long' error or struggling with Excel's Find and Replace tool when it fails to locate them due to length restrictions.
  • Easier to find and replace special characters such as:
          ·  Use {lf} to find and replace line feeds (Alt+Enter / ASCII code 10)
          ·  Use {cr} to find and replace carriage returns (ASCII code 13)
          ·  Use {tab} to find and replace tab characters (ASCII code 9) Customizable search options:
  • Find in all worksheets, current worksheet, or selected range
  • Search by rows or columns
  • Look in formulas or values
  • Match case
  • Match entire cell contents
  • Match entire words or phrases only By default, you can launch this tool using the Control+Alt+H shortcut. Historical Note:
    ASAP Utilities introduced search across the entire workbook at once in 1999, long before Excel added this feature in 2007.

    Screenshots

    Example screenshot: 1
    1, Range  ›  1 Advanced Find and Replace...
    Example screenshot: 2
    2, Range  ›  1 Advanced Find and Replace...

    Starting this tool


    Range  ›  1 Advanced Find and Replace...
    Additional keywords for this tool:
    Find and replace whole words only, Match entire words, Find and replace multiple worksheets, Match entire words, Find carriage returns in Excel, Replace line breaks, Remove tab characters in Excel, Fix Excel formula too long error, Excel find and replace not working, Search long text values in Excel, Replace text limit workaround, Find and replace with wildcards in Excel, Search for Alt+Enter in Excel



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