Replace Words in Excel: Find and Replace Guide

How-to basics · Updated November 20, 2026

To replace a word in Excel, press Ctrl+H on Windows, enter the existing word in Find what and the new word in Replace with, then choose Replace or Replace All. Check the search scope and matching options first so you do not change unintended cells. On a Mac, open Edit > Find > Replace. The steps below apply to Excel for Microsoft 365 on Windows; the dialog may look slightly different on Mac or Excel for the web.

What You’ll Need

  • An Excel workbook with the text you want to change. Save a copy first if the replacement affects important information or many sheets.
  • The exact existing text and the replacement text. Pay attention to spaces, punctuation, and capitalization.
  • Access to the workbook in Excel. If the file is read-only or protected, you may need permission to edit it before replacing content.

Step-by-Step

  1. Open the workbook and decide where to search. Identify whether the word appears on one worksheet, in a particular range, or across the workbook. If there are formulas, labels, notes, or imported data nearby, decide whether those should be included too. Save before making a wide-ranging change so you have a clean copy to return to if needed.
  2. Optionally select a range to limit the replacement. On the worksheet, drag across the cells you want to include. Excel generally limits Find and Replace to the selected cells when a range is selected. If you want to search a whole sheet or workbook, click a single cell instead of leaving a range selected, then set the scope in the dialog. Check the selection before continuing; a selection left over from earlier work can make it seem as if Excel missed other matches.
  3. Open the Replace dialog. In Windows, press Ctrl+H, or use Home > Find & Select > Replace. On a Mac, use Edit > Find > Replace; keyboard shortcuts can differ with the keyboard and Excel version. In Excel for the web, use the Home tab’s Find & Select control and choose Replace if that option is available in your interface. If it is not available, open the workbook in the desktop app.
  4. Enter the text to find and the replacement. In Find what, type the word or phrase as it appears in the cells. In Replace with, type the new word or phrase. For example, to change the department name Sales to Customer Care, enter Sales in the first box and Customer Care in the second. To remove text, leave Replace with empty. Avoid adding extra spaces unless you intend them to remain before or after the replacement.
  5. Review the search options. Choose Options if the additional settings are hidden. Set Within to Sheet to limit the search to the active worksheet, or Workbook to include sheets in the workbook. Look in controls whether Excel searches formulas, values, or other available content such as notes. For ordinary text entries, use Values if available; choose Formulas only when you intend to find text in formula expressions. Options and labels can vary slightly between desktop versions. Search direction affects the order Excel checks cells, not which text qualifies as a match.
  6. Choose how exact the match should be. Select Match case if capitalization matters, such as changing the uppercase code ID but not the lowercase word id. Select Match entire cell contents only when a cell must contain nothing except the search text. For example, with that option selected, a cell containing Sales West will not match Sales. This is not a whole-word setting: Excel’s built-in dialog does not offer a general whole-word-only checkbox, so a search for cat can match cat inside catalog if Match entire cell contents is off.
  7. Test one match before changing everything. Choose Find Next to move to a match and inspect its cell. If the result is unexpected, stop and adjust the search text, selection, or options. When the match is right, choose Replace to change only that occurrence and continue one at a time. This is a sensible approach when the word appears in different contexts or the workbook contains formulas you need to protect.
  8. Replace all only when the scope is correct. Choose Replace All to change every matching occurrence within the selected range and configured sheet or workbook scope. Read the confirmation message, which reports how many replacements Excel made. If the number is surprising, do not continue editing: inspect the results and use Ctrl+Z on Windows, or Command+Z on Mac, immediately if the replacement is the most recent action and Excel allows it to be undone. A saved backup is a safer fallback.
  9. Check the results and save. Look at several changed cells, including examples near the beginning and end of the data. Search again for the old text to see whether any matches remain in the chosen scope. Some remaining matches may be intentional, such as different capitalization when Match case was enabled. Confirm formulas and related totals still behave as expected, then save the workbook.

Common Mistakes

Replacing a fragment unintentionally: Searching for a short string can change it inside longer words. A search for art, for instance, can find the same letters in words such as artist. Excel’s Match entire cell contents option prevents matches inside longer cell contents, but then it only matches cells made up of the exact search text. It does not provide a general whole-word boundary check within a sentence.

Searching the wrong area: A selected range can narrow the operation, while choosing Workbook instead of Sheet broadens it. Confirm both the selected cells and the Within setting before choosing Replace All.

Changing formulas unintentionally: If Look in is set to Formulas, the search can find text within formula expressions. A broad replacement may alter formulas, not just the words displayed in cells. If you are changing ordinary labels, use the appropriate value search and avoid formula scope unless that is the goal.

Overlooking case or spaces: Match case can exclude differently capitalized versions, and an extra space in either box can leave awkward spacing or prevent the expected match. Check the exact text before replacing.

Tips

  • Use Replace for a small number of changes and Replace All only after a test. The one-at-a-time approach makes it easier to spot a false match before it spreads.
  • For a workbook-wide change, use a copy first and select Workbook deliberately. A word may appear in headings, notes, formulas, or sheets that were not part of your original intention.
  • When you only want cells that contain an exact full entry, use Match entire cell contents. For example, it can replace a cell that contains only Pending without changing a sentence such as Pending review.
  • To replace a phrase, search for the full phrase rather than a short portion of it. This reduces accidental matches and helps preserve words that happen to contain the same letters.
  • If your search text includes wildcard characters such as * or ?, Excel may treat them as search patterns. To search for a literal wildcard character, put a tilde before it in Find what; for example, ~* searches for an asterisk. Test this on one match before replacing all.
  • Keep a note of the old and new wording when standardizing names or labels. This makes it easier to explain the change and repeat it consistently in another workbook.

Troubleshooting

Excel says there are no matches: Check spelling, punctuation, spaces, and capitalization. Clear Match case if you do not need case-sensitive matching. Confirm that the correct worksheet or range is active, that the search is looking in the intended content type, and that Within is set to the right scope. If the target text is produced by a formula, searching values may not behave like searching the formula text; inspect the formula and choose the appropriate Look in setting.

Replace All changes too many cells: Stop editing and undo immediately if possible. Reopen the dialog, select a smaller range or set Within to Sheet, and use Find Next to inspect a sample before trying again. If the workbook has since been edited or closed, restore the saved copy rather than assuming undo will recover the original state.

The displayed word does not change: Check whether the cell is formula-driven. Replacing text in the underlying formula is different from changing a displayed result, and replacing formula text can affect how the cell calculates. Also check whether the sheet or workbook is protected, or whether the file is read-only. Resolve the restriction or edit the source data instead of repeatedly running the same replacement.

Only some versions of the word changed: Match case may be enabled, the search may cover only part of the data, or some cells may contain extra characters. Search again with less restrictive options and inspect the remaining cells individually. If you need whole-word matching inside longer sentences, Find and Replace alone may not be sufficient; consider reviewing filtered results or using a carefully checked text-cleanup method.

The result has odd spacing or punctuation: Review the exact replacement text and the characters around the matched text in the original cells. Replacing a word does not automatically correct neighboring spaces, commas, or capitalization. Undo if appropriate, then test the revised replacement on one cell.

Frequently Asked Questions

How do I replace a word everywhere in an Excel workbook?
Press Ctrl+H, enter the old and new text, set Within to Workbook, confirm the other options, and choose Replace All. Save a copy first and verify that every sheet is meant to be included.

Can I replace a word in only one column?
Yes. Select the cells in that column that you want to change before opening Replace, then check the selection and options. Alternatively, search the worksheet and use Find Next to review matches before replacing them one at a time.

Can Excel replace part of a word?
Yes. With Match entire cell contents turned off, Excel can replace matching text within a longer cell entry, including part of a word. That can create unwanted edits, so use a longer search phrase or inspect matches before using Replace All.

Can I replace a word without changing capitalization?
Excel inserts the text entered in Replace with; it does not reliably adjust the replacement’s case to match each occurrence. If capitalization matters, use Match case and make separate replacements for the forms you want to change.

How do I remove a word instead of replacing it?
Enter the word in Find what and leave Replace with blank, then choose Replace or Replace All. Check for leftover spaces or punctuation, because Excel removes the matched text but does not automatically tidy surrounding characters.

Can I undo Replace All?
Often, Ctrl+Z on Windows or Command+Z on Mac reverses a recent Replace All. Undo availability depends on what you have done since the replacement, so save a backup before broad changes and use it if undo is unavailable.

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.