Excel Find and Replace: Change One Word to Another Quickly

How-to basics · Updated November 20, 2026

To replace one word with another in Excel, press Ctrl+H on Windows, enter the old word in Find what and the new word in Replace with, then choose Replace or Replace All. For a one-time change across selected cells or a worksheet, Find and Replace is usually the quickest method; a formula is better when you want to keep the original text and create revised results in another column.

Replace a word with Find and Replace

In Excel for Microsoft 365 on Windows, you can open the replacement dialog with Ctrl+H, or choose Home > Find & Select > Replace. The dialog has two main boxes: Find what is the text you want to change, and Replace with is the text to put in its place.

  1. Enter the old word or phrase in Find what.
  2. Enter its replacement in Replace with. Leave this box empty if you intend to remove the matching text.
  3. Choose Find Next to inspect matches one at a time, or select Replace All to change every match in the search scope.
  4. Read Excel’s message reporting how many replacements were made, then close the dialog and review the affected cells.

For example, if a list contains “North Depot” and you need to rename it “Central Depot,” search for North and replace it with Central. If that word occurs in many cells, Replace All can update them together. If the workbook contains unrelated uses of “North,” inspect matches individually or narrow the search before applying a bulk replacement.

Choose where Excel searches

The replacement dialog’s options determine how broad the change is. If you do not select a range first, Excel generally searches the active worksheet. If you select a range of cells before opening the dialog, the search can be limited to that selection. This is useful when the same word appears in several parts of a sheet but only one table should change.

Expand the dialog’s options when you need to control the search further. The Within setting can limit the search to the current sheet or extend it to the workbook. A workbook-wide replacement can affect multiple sheets, so check the scope before choosing Replace All. The Look in setting lets you choose what Excel searches, such as formulas or values; the available choices can vary with the Excel version and context.

Search scope matters especially in workbooks with formulas. A cell may display a word because a formula creates it, rather than because that word is stored as ordinary text. If the displayed wording comes from a formula, changing the formula or its source data is usually the right fix. Searching formulas can also find text inside formula expressions, so do not treat every match as a visible cell value.

Match a whole cell or a text fragment

By default, Find and Replace can match text within a cell. Searching for art, for instance, may also find that sequence inside article or cart. That behavior is useful when you intend to change a fragment, but it can create unwanted edits if you mean to replace a standalone word.

Open the dialog’s options and select Match entire cell contents when the cell must contain only the searched text to count as a match. This is appropriate for a category column containing a single value such as “Pending.” It is not a word-boundary setting: it will not find “Pending” as a separate word inside a longer cell such as “Pending review.” Excel’s standard replacement dialog does not provide a general “whole word only” switch for text embedded in sentences. For that case, inspect matches, use a more specific phrase or delimiter, or build a formula suited to the data.

Excel’s search is not case-sensitive by default. To distinguish “May” from “may,” expand the options and enable Match case. Check this setting when capitalization carries meaning, such as in product codes, abbreviations, or names. If capitalization should be preserved or changed in a particular way, test a few examples first; a simple global replacement does not automatically infer the correct capitalization for every sentence.

Replace all occurrences or just one

Replace changes the current match and moves through the results, which gives you a chance to review each one. Replace All changes every match within the selected search scope. Use Replace when the matches need individual judgment, and use Replace All when the target text is unambiguous and the range is controlled.

“All occurrences” means all matches found under the current search options, not necessarily every instance in every open workbook. Confirm the active sheet or selection, the Within setting, and any case or whole-cell options before applying the bulk command. For a large workbook, a narrower selection is often safer than relying on memory about where the text appears.

Use a formula to keep the original text

Find and Replace edits the existing cell contents. If you want to preserve the source and display a modified version elsewhere, use the SUBSTITUTE function. With the original sentence in A2, enter =SUBSTITUTE(A2,"blue","green") in another cell. If A2 contains “The blue bus is blue,” the result is “The green bus is green.” The formula replaces every matching instance of the specified text in that cell.

To replace only a particular occurrence, add the optional occurrence number. With the same text in A2, =SUBSTITUTE(A2,"blue","green",2) returns “The blue bus is green,” changing the second occurrence only. SUBSTITUTE is case-sensitive, unlike Find and Replace when its Match case option is off. It also returns a result rather than changing the source cell. To make the results permanent, copy the formula results and use Paste Special > Values where appropriate, taking care not to overwrite the original data before you have checked it.

A formula is especially useful when you need an auditable before-and-after column, want to apply the same transformation to many rows, or need to preserve a source list. Fill the formula down alongside the data and inspect the results before using them elsewhere. If only an occasional one-off correction is needed, the dialog is simpler.

Understand wildcards and special characters

Find and Replace supports wildcard characters for pattern searches. An asterisk (*) can represent any sequence of characters, and a question mark (?) can represent one character. For example, a search pattern like pre* can match text beginning with “pre” and continuing with other characters. This can be powerful, but it may match more than a reader expects, so use Find Next to check the pattern before replacing all results.

If you need to search for an actual asterisk or question mark rather than use it as a wildcard, put a tilde before it: ~* searches for a literal asterisk and ~? for a literal question mark. Wildcards are not a substitute for a whole-word option; they describe patterns, and a broad pattern can still match unexpected text. When precision matters, make a copy of the data or test on a small range first.

Common problems and how to avoid them

  • Too many matches: The search may be matching part of longer words. Use a more distinctive phrase, select a smaller range, or review matches one by one.
  • No matches found: Check spelling, spaces, punctuation, the active worksheet, the selected range, and whether Match case or Match entire cell contents is enabled. Also verify the Look in setting.
  • Only some rows changed: The active selection or Within setting may have limited the search. Reopen the dialog and confirm the scope before trying again.
  • Formulas changed unexpectedly: The word may occur inside a formula, or the visible result may be generated from another cell. Review Look in and edit the underlying formula or source instead when appropriate.
  • Spacing looks wrong: The replacement text does not automatically add spaces around itself. If replacing a phrase within a sentence, include the intended spaces in the search or replacement text and check punctuation afterward.

One common misconception is that replacing a word changes only standalone occurrences. Unless you enable Match entire cell contents, Excel can replace matching characters within a longer cell entry. Another is that Replace All always searches the whole workbook; the actual scope depends on the dialog settings and the selection. Checking these two details prevents many accidental bulk edits.

Review changes and recover if needed

After a replacement, inspect representative cells at the beginning, middle, and end of the affected range. For a large set of changes, check the replacement count against what you expected and search for the old text again. A remaining match may be legitimate, outside the selected scope, or excluded by a case or whole-cell setting.

Excel normally lets you undo a recent replacement with Ctrl+Z on Windows. Undo promptly if the result is wrong, before making other edits that complicate recovery. For a high-impact workbook, save a copy before a workbook-wide replacement; this gives you a fallback even if you close the file or cannot conveniently undo the change. Reviewing a small sample before Replace All is faster than repairing a broad unintended edit.

Excel for Mac and Excel for the web

On a Mac, use Excel’s Home > Find & Select > Replace command to open the same kind of replacement controls; ribbon layout and keyboard shortcuts can differ from Windows. In Excel for the web, look for Find & Select and Replace on the Home tab. The browser can reserve some keyboard shortcuts for its own functions, so the ribbon command is a dependable alternative. Dialog options and their placement can vary slightly among desktop, Mac, and web releases, but the basic process—specify the text, check scope, then replace—is the same.

Frequently Asked Questions

How do I replace a word in Excel without changing part of another word?
Use Match entire cell contents if each cell contains only the target word. If the word appears inside longer text, Excel’s dialog has no general whole-word-only option; narrow the selection or review matches individually.

Can I replace a word in every sheet at once?
Yes. In the replacement dialog, set Within to Workbook if that option is available, then verify the scope and review matches before choosing Replace All. A workbook-wide change can affect sheets beyond the one currently visible.

How do I replace only the first occurrence in a cell?
Use a formula if you need a controlled result while retaining the original text. SUBSTITUTE can target a numbered occurrence, such as the first, second, or third; the replacement dialog is designed to search matches across the selected scope rather than specify an occurrence within each cell.

Can Excel replace text in formulas?
It can search formula contents when the dialog’s Look in setting is set to formulas. Be cautious: changing text within a formula can alter how it works. If the displayed word is produced by a formula, edit the formula or its source data instead of treating the display as ordinary typed text.

How can I remove a word instead of replacing it?
Enter the word in Find what and leave Replace with blank. Check whether the word is part of longer text and whether spaces or punctuation should also be removed, then use Find Next to inspect examples before choosing Replace All.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.