Excel Find and Replace: Search, Change, and Fix Text

To find and replace text in Excel for Microsoft 365 on Windows, press Ctrl+H, enter the text to find and its replacement, then choose Replace or Replace All. Use Replace to review matches one at a time; choose Replace All to change every match in the selected range or the area you specify.

What Find and Replace does

Find and Replace searches cell contents for text and can substitute new text for matching characters or words. It is useful for correcting repeated typos, updating a product name, standardizing labels, or changing a code used throughout a worksheet. For example, if a list contains “West Divison” many times, you can search for that spelling and replace it with “West Division.”

Excel does not treat this as a writing-only tool. Depending on the search settings, it can look at displayed values, formulas, or notes, and a replacement can affect a formula’s text as well as ordinary text in a cell. That makes it powerful, but also a reason to check the search scope and settings before choosing Replace All.

Find and Replace changes cell contents; it is not the same as changing number formats, applying a filter, or editing the underlying structure of a table. Replacing a word in a text label is straightforward. Replacing a character in formulas, dates, or identifiers needs more care because the same characters may have a different meaning in those contexts.

How to find and replace text

On Windows, open the worksheet and press Ctrl+H. You can also use Home > Find & Select > Replace. In the dialog, enter the existing text in Find what and the new text in Replace with. Choose Find Next to inspect a match, Replace to change that match and move on, or Replace All to apply the change throughout the search area. Excel reports how many replacements it made.

If only part of a worksheet should change, select that range of cells first. Otherwise, Excel searches the current sheet by default.
Open Find and Replace and enter the old and new text. Leave Replace with blank if the intention is to remove the matched text.
Use Options to check the search location and matching rules. Confirm whether Excel should search the sheet or workbook and what content it should inspect.
For a controlled change, choose Find Next, review the cell, and use Replace. For a verified global change, choose Replace All.
Look over the affected cells afterward. If the result is wrong, use Ctrl+Z immediately to undo the operation.

On a Mac, Excel also provides Find and Replace from the Edit menu or the Home tab’s find controls; keyboard shortcuts can differ with the keyboard layout and Excel release. In Excel for the web, use the Home tab’s find controls. The web interface may offer fewer search options than the Windows desktop dialog, so use desktop Excel when you need detailed control over workbook-wide searches or formula content.

Control where Excel searches

Before replacing text, decide whether the operation belongs in one range, one worksheet, or the whole workbook. Selecting a range first is a practical way to constrain the operation to, for instance, the “Status” column instead of changing a matching word in notes or other fields. Without a selection, the dialog’s Within setting determines whether Excel searches the current sheet or the workbook.

The Options area also controls how Excel interprets a search. Search by Rows or Search by Columns changes the order in which it moves through cells; it does not limit which cells qualify. Look in determines what Excel searches. Depending on the version and context, choices include formulas, values, and notes. “Formulas” means Excel searches formula text, while “Values” refers to the results shown in cells. These are not interchangeable: a cell may display 12 while its formula contains a longer expression.

For example, a worksheet might show “Approved” because a formula returns that word. Searching values can locate the displayed result, whereas searching formulas can find text written inside the formula itself. If a search appears to miss something, check Look in before assuming the text is absent.

Match settings, case, and whole-cell searches

Two checkboxes can make a major difference. Match case distinguishes uppercase and lowercase letters, so a search for “ID” will not necessarily match “Id” when this option is selected. Match entire cell contents requires the whole cell to equal the search text. With that option off, searching “East” can also find “Northeast” or “East Office.”

These settings are helpful when a short search term occurs in many unrelated labels. Suppose a sheet contains “HR,” “HRA,” and “North HR Team.” Searching for HR with Match entire cell contents on targets only a cell whose entire content is HR. If the goal is to replace HR wherever it appears within a longer label, leave that option off and review the potential matches.

Excel can also search for formatting through the Format controls in the dialog’s Options. This is useful when the target cells share a distinctive format, but format-based searches can be confusing if the search dialog retains formatting from an earlier task. If text searches behave unexpectedly, clear or reset the search format and check the other options again.

Using wildcards for flexible searches

Wildcards let you find text when part of the content varies. In Excel’s Find and Replace dialog, an asterisk (*) represents any number of characters, and a question mark (?) represents one character. For example, searching for “inv*” may find entries beginning with “inv” followed by different text. Searching for “col?r” can find “color” or “colour” only when the pattern and character count fit; the question mark represents one character, not an optional one.

Use * when the length or content of a section is unknown, such as “North*” for labels that begin with “North.”
Use ? when exactly one character may vary, such as “A?7” for three-character codes with any one middle character.
Put a tilde before a wildcard to search for that character literally: ~* finds an asterisk, ~? finds a question mark, and ~~ finds a tilde.

Wildcards can make Replace All especially broad. A pattern such as “*” can match far more than a single phrase, so test wildcard searches with Find Next and confirm the intended scope before replacing anything. If the goal is a literal asterisk or question mark, escape it with a tilde rather than treating it as a wildcard.

Replacing text in formulas and identifiers

When Look in is set to formulas, Find and Replace can alter the formula text itself. That can be useful for a deliberate reference update, but it can also change calculation logic. For example, replacing one column letter across a workbook might alter formulas that refer to that column, including formulas where the letter appears as part of a sheet name or text string. Inspect formulas and results after any formula-level replacement.

Be cautious with dates, account numbers, postal codes, and other identifiers. Excel may store a displayed value differently from how it appears on screen; a date formatted as “Nov 2, 2026” is stored as a serial number, for example. A text search may therefore not match the date exactly as displayed. Identifiers with leading zeros are often best stored as text if those zeros are meaningful. Replacing characters in a column of mixed text and numbers can produce inconsistent results.

If the required change is a transformation rather than a simple repeated substitution—for example, splitting names, extracting part of each code, or applying several rules—use a helper column with a formula or a data-cleaning workflow instead. That lets you compare original and revised values before replacing the source data.

Common problems and safer checks

No matches appear: Check the selected range, Within setting, Look in choice, Match case, and Match entire cell contents. Also confirm that the target is not being shown as a formula result while Excel is searching formulas, or vice versa.
Too many cells change: Undo promptly with Ctrl+Z, narrow the selection, enable whole-cell matching if appropriate, or replace one match at a time.
Text inside formulas changes: Check Look in and review the formulas. A replacement can change references or formula text rather than only visible labels.
The replacement is incomplete: The original may occur in different capitalization, spelling, or formats, or the search may have been restricted to a range or sheet. Repeat the search with settings suited to the remaining cases.
A wildcard finds surprising results: Remember that * can match many characters and ? matches one. Escape a wildcard with ~ when it is part of the literal text.

For important workbooks, save a copy before a broad replacement. Afterward, review a sample of changed cells and check key totals, formulas, and labels. Ctrl+Z is useful for an immediate reversal, but saving a separate copy gives you a safer fallback if other edits are made before a problem is noticed.

When to use Find instead

Use Find when you need to locate information without changing it. Press Ctrl+F on Windows or choose Home > Find & Select > Find, then enter the search text and move through matches. Finding first is a good way to estimate how widespread a typo is, confirm that the correct cells are being targeted, and decide whether a replacement should be global or selective.

For a handful of cells, direct editing may be simpler than creating a global rule. For a large, repeatable cleanup, Power Query or formulas may be more suitable because they can show a transformed result separately and can be refreshed or checked before the source is overwritten. Find and Replace is best for a clear, consistent text change—not for interpreting ambiguous records or repairing complex data structures automatically.

Frequently Asked Questions

What is the shortcut for Find and Replace in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+H to open Replace. Ctrl+F opens Find. On a Mac, use the Edit menu or the Home tab’s find controls if the Windows shortcut does not work with your keyboard or Excel version.

Can I replace text in the entire workbook?
Yes. Open the Replace dialog, expand Options, and set Within to Workbook if that choice is available. Check the search content and matching options first; a workbook-wide replacement can affect many sheets, including formula text if formulas are being searched.

How do I delete a word from cells?
Enter the word or text in Find what and leave Replace with empty, then choose Replace or Replace All. Use Match entire cell contents if you want to clear cells containing only that word rather than remove it from longer labels.

Can Excel find part of a cell’s text?
Yes. Leave Match entire cell contents unchecked to find a term within a longer cell entry. You can also use * and ? as wildcards for variable text, and a tilde to search for a wildcard character literally.

Why does Find and Replace miss text I can see?
Excel may be searching formulas instead of displayed values, or vice versa. It may also be limited to a selected range or the current worksheet, or have Match case or Match entire cell contents enabled. Check those settings and try Find Next before replacing.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.