Replace Words in Excel: Find and Replace Guide

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace, enter the existing word in Find what and its substitute in Replace with, then choose Replace to review matches one at a time or Replace All to change every match in the chosen search area. Check the search options before using Replace All, because the command can change more cells or parts of formulas than you intend.

How Find and Replace works

Find and Replace searches worksheet content for text, numbers, or—in some cases—characters in formulas, then substitutes the replacement you specify. It is an editing command: unlike a formula, it changes the selected cell contents rather than creating a live result beside the original. Excel does not automatically know whether a word is a typo, a proper name, or part of a longer term, so the search settings and a quick review matter.

On Windows, open the worksheet and press Ctrl+H, or use Home > Find & Select > Replace. In the dialog:

  1. Type the text to locate in Find what.
  2. Type the new text in Replace with. Leave this box empty if your goal is to remove the matched text.
  3. Choose Find Next to inspect a match, Replace to change that match, or Replace All to apply the change throughout the selected search area.
  4. Read Excel’s confirmation message after Replace All. It reports how many replacements were made.

For example, replacing the text “Dept.” with “Department” can standardize a label across a list. If a cell contains “Dept. of Parks,” the result is “Department of Parks.” Replacing “cat” with “dog,” however, may also change “catalog” to “dogalog” unless you limit the match to entire cell contents or otherwise make the search more specific.

Choose the search area before replacing

The scope determines where Excel looks. If a range is selected before you open Replace, Excel can restrict the operation to that selection. With no range selected, the search generally applies to the active worksheet. The Within setting can let you choose the current sheet or the workbook, depending on the dialog’s available options. A workbook-wide replacement is useful for a consistent label used on several tabs, but it raises the risk of changing unrelated data.

Open Options in the Find and Replace dialog to review the scope and matching behavior. Useful settings include:

  • Within: Choose Sheet or Workbook when that choice is available. Confirm the active sheet or workbook scope before using Replace All.
  • Search: Choose whether Excel searches by rows or columns. This changes the order in which Find Next visits matches, not which cells qualify.
  • Look in: Choose whether to search values or formulas where those choices are offered. Searching formulas can find text inside a formula, not just what the cell displays.
  • Match case: Turn this on when capitalization distinguishes the text you want to change.
  • Match entire cell contents: Turn this on when only cells equal to the search text should qualify, rather than cells that contain it as part of a longer entry.

Search options may remain set from an earlier search, so do not assume the dialog has returned to its default state. If a replacement finds zero matches, or unexpectedly changes many, check these options and the selected range first.

Use Replace All carefully

Replace All is fastest for a deliberate, consistent edit, such as correcting a known misspelling in a column. For ambiguous text, use Find Next and Replace to inspect matches individually. That lets you skip a legitimate occurrence while changing a typo elsewhere. If Excel reports more replacements than expected, press Ctrl+Z immediately to undo the operation, then review the scope and search term before trying again. Undo is not a substitute for checking the workbook, especially if you make other edits afterward.

Before a large or workbook-wide replacement, consider saving a separate copy of the file. This is particularly sensible when the workbook is shared, contains important formulas, or has a complex layout. You can also test the operation on a small selected range first. If the replacement affects dates, codes, or identifiers, inspect the resulting cells: Excel may store a value differently from the way its number format displays it, and a search for visible text may not behave like a search for the underlying value.

Replacing part of a formula deserves extra caution. If Excel is set to look in formulas, the search can match text written inside formulas, such as a text label used by a formula, or text that forms part of a reference. A replacement can therefore alter how a formula works. When the goal is to change displayed text produced by formulas, changing the source data or the formula itself may be more appropriate than running Replace All across formulas.

Find whole words and use wildcards

Excel’s Match entire cell contents option is not the same as a word-boundary search. It matches a cell only when the cell’s complete contents equal the search term. For instance, it can distinguish a cell containing “East” from “East Office,” but it does not mean “find East as a separate word anywhere in a sentence.” Excel’s standard Find and Replace dialog does not provide a general-purpose whole-word boundary checkbox. If you need that distinction in longer text, inspect matches individually or use a more controlled text-processing method.

The Find what box also supports wildcard characters. An asterisk (*) stands for any number of characters, and a question mark (?) stands for one character. A tilde (~) escapes a wildcard when you need to find it literally. For example, searching for “plan?” can match “plans” or “plant,” because the final question mark represents one character. Searching for “plan*” can also match longer entries beginning with “plan.” Use wildcards only when the range and possible matches are well understood; a broad pattern can capture many unintended cells.

To find an actual question mark or asterisk rather than use it as a wildcard, put a tilde before it in Find what: ~? finds a literal question mark, and ~* finds a literal asterisk. These rules apply to the search pattern. If a wildcard search is confusing, try Find Next on a few examples before replacing anything.

Replace text with a formula instead

Find and Replace is best when you want to edit existing values once. A formula is a better choice when you want to preserve the source text and calculate a changed version in another cell. The SUBSTITUTE function replaces specified text within a text value. With the original text in A2 and the replacement result in B2, enter =SUBSTITUTE(A2,"North","Central") in B2. If A2 contains “North Region – North Region,” B2 returns “Central Region – Central Region,” because SUBSTITUTE replaces every matching occurrence by default.

To change only a particular occurrence, SUBSTITUTE accepts an optional instance number. With the same text in A2 and the result in B2, enter =SUBSTITUTE(A2,"North","Central",1). For “North Region – North Region,” the result is “Central Region – North Region”: only the first occurrence changes. Copy the formula down to process other rows, then, if you need fixed text rather than formulas, copy the results and use Paste Special > Values.

REPLACE is a different function: it substitutes characters by position, not by searching for a word. With “AB-1234” in A2 and the result in B2, =REPLACE(A2,4,4,"5678") returns “AB-5678” because it replaces four characters beginning at position 4. Choose SUBSTITUTE when the target is text you can name; choose REPLACE when the position and number of characters are what matter. These functions are available in current Excel versions, including Microsoft 365.

Common problems and how to avoid them

A replacement that does not work as expected often has a simple cause. Check for extra spaces, punctuation, different spelling, or a search option left over from a previous task. Excel’s ordinary text matching is not the same as a language-aware search: an accented character, a nonbreaking space copied from a website, or a typographic apostrophe may differ from the character you typed. If the apparent text is identical but Find does not locate it, inspect the source cell and consider testing a shorter, distinctive part of the text.

  • Too many results: Narrow the selected range, change Within to Sheet if the workbook scope is active, turn on Match entire cell contents where appropriate, or replace one match at a time.
  • No results: Check spelling, spaces, Match case, the Look in choice, and whether you are searching formulas or values.
  • Numbers or dates behave oddly: Verify the cell’s stored value and number format. A displayed date is formatted from a stored date value, so searching its visible form may not be equivalent to searching the stored content.
  • Formulas change unexpectedly: Undo promptly and check whether Look in is set to formulas. Restrict the search to the relevant input cells rather than the whole workbook.
  • Only some text changes: Confirm that the search term matches the precise characters in each cell. Different capitalization matters when Match case is enabled.

Excel can also search for formatting through the Format controls in Find and Replace. That is separate from replacing words: use it when you need to locate or replace cell formatting, and clear any prior format criteria if text searches suddenly return unexpected results. A stale format condition can constrain a search even when the text boxes look correct.

Excel for Mac and Excel for the web

In Excel for Mac, the Replace command is also available through the Find and Replace interface; the keyboard shortcut can differ according to the Mac keyboard and Excel setup. If Ctrl+H does not open the expected dialog, use Excel’s Edit or Home menu to open Find and Replace rather than relying on a Windows shortcut. Review the same search scope and matching options before replacing. Keyboard shortcuts can also be affected by macOS settings or keyboard layouts.

Excel for the web provides Find and Replace through its Home tab, though the interface and available options can differ from the Windows desktop version. If you cannot find a particular setting or need a more extensive workbook-wide operation, open the file in the desktop app and verify the scope there. In every version, the key distinction remains: Replace changes cell contents, while a formula can display a transformed result without overwriting its source.

Frequently Asked Questions

Can I replace a word in every sheet in an Excel workbook?
Yes, if the Find and Replace dialog offers Within: Workbook, select it before using Replace All. Check the results and save a copy first if the change is substantial, since the same word may have different meanings on different sheets.

How do I remove a word from cells in Excel?
Open Ctrl+H, enter the word in Find what, leave Replace with blank, and choose Replace or Replace All. If the word may occur inside other words, avoid a broad Replace All unless changing those longer terms is also intended.

Can Excel replace only the first occurrence in a cell?
Find and Replace generally applies the specified replacement to each qualifying match when you choose Replace All; it does not offer the same per-cell occurrence selector as a text formula. Use SUBSTITUTE with an instance number when you want a formula result that changes a particular occurrence.

Does Replace All change formulas?
It can, depending on the Look in setting and the search scope. If formulas are included, a match inside a formula may be replaced and alter its result or references. Check the setting and limit the range before proceeding.

Can I undo Replace All?
Usually, Ctrl+Z on Windows undoes a recent Replace All operation if it is still the most recent action. On Mac, use Command+Z. If you have made later changes or the workbook was closed, undo may no longer be available, so save a backup before a broad replacement.

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.