Home Screenshots 10 Languages Why use it?

Tip of the Day | Friday May 22nd, 2026

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

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

Example screenshot: 2

Starting this tool

Click ASAP Utilities › Text › 14. Advanced Find and Replace...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.