To replace several different words in Excel, use Ctrl+H and run Find and Replace once for each word, or use a formula with nested SUBSTITUTE functions to change multiple terms in one pass. For Microsoft Excel for Microsoft 365 on Windows, Ctrl+H opens the replacement dialog; the best method depends on whether you want to edit the original cells, keep the original text, or repeat the task regularly.
What “replace multiple words” can mean
The request usually describes one of two tasks: replacing several different terms, such as “NY” and “Mgr,” or replacing a phrase made up of several words, such as “old product name.” Excel can do either, but the steps differ. Find and Replace handles one search term at a time. A formula can apply several replacements to each cell’s text, while Power Query is useful for repeatable data-cleaning work.
It also matters whether the replacement should change the source data. Find and Replace edits cells directly. A formula returns changed text in a separate cell, leaving the source intact. Power Query creates a transformed result that can be refreshed from the original data.
Replace terms with Find and Replace
For a small number of replacements, Excel’s built-in command is usually the quickest choice. In Windows desktop Excel, select the cells you want to change, press Ctrl+H, enter the original term in “Find what,” and enter its substitute in “Replace with.” Choose Replace to check a match before changing it, or Replace All to change every match in the search scope. Repeat the process for each additional term.
- Select the relevant cells, or leave the sheet unselected if the replacement should apply throughout it.
- Open Home > Find & Select > Replace, or press Ctrl+H.
- Enter one search term and its replacement, then review the options before using Replace All.
- Run the command again for each other word or phrase.
In the dialog’s options, check “Within” to choose whether to search the current sheet or the workbook, and check “Look in” to control whether Excel searches formulas, values, or comments where available. A selected range limits the operation to that range. If you choose Replace All, Excel reports how many replacements it made; review the affected cells before continuing with other terms.
On a Mac, use Edit > Find > Replace; keyboard shortcuts can differ by keyboard and Excel version. Excel for the web has a more limited interface than desktop Excel, so check its Find and Replace controls if a desktop option is missing. The basic principle is the same: each Find and Replace operation searches for one term.
Change several terms with a formula
A formula is appropriate when you want to preserve the original text and produce a cleaned version in another column. SUBSTITUTE replaces matching text wherever it occurs in a cell. You can nest the function so that the output of one replacement becomes the input to the next. This is useful for a manageable list of substitutions that you can review and maintain.
With the original text in A2, replace “NY” with “New York” and “Mgr” with “Manager” using this formula in B2:
=SUBSTITUTE(SUBSTITUTE(A2,"NY","New York"),"Mgr","Manager")
If A2 contains “NY Mgr,” the result in B2 is “New York Manager.” Copy the formula down to process other rows. To keep only the changed text, copy the results and use Paste Special > Values over the appropriate destination cells; check the destination first so you do not overwrite the originals unintentionally.
The order of nested replacements matters. Excel performs the inner SUBSTITUTE first, then applies the outer one to its result. If an early replacement creates text that matches a later search term, the later replacement can alter that newly created text too. Plan the order and test a few representative rows, especially when search terms overlap.
Understand exact matches, case, and word boundaries
SUBSTITUTE replaces matching character sequences, not necessarily whole words. For example, replacing “art” can also change “carton” because those letters appear inside the longer word. It is case-sensitive: searching for “cat” does not replace “Cat” with that formula. If your data has inconsistent capitalization, standardize it first or use a different approach suited to the data.
Find and Replace is generally case-insensitive unless you enable “Match case” in its options. Its “Match entire cell contents” option is different from a whole-word search: it restricts the match to cells whose entire contents equal the search text. It does not mean “replace this word only when it appears between spaces.” If you need whole-word matching within longer sentences, inspect the results carefully or use a method designed around the data’s separators and word rules.
Find and Replace also supports wildcard searches. An asterisk represents any number of characters, a question mark represents one character, and a tilde can be used to search for a literal wildcard character. Wildcards are useful for patterns, but they are not a way to supply several unrelated search terms in one operation. A broad pattern can match more than intended, so test it before choosing Replace All.
Replace a multiword phrase
If the target is one phrase containing spaces, enter the whole phrase in “Find what” and its new wording in “Replace with.” For instance, you can replace “North Region” with “Northern Region” using a single Find and Replace operation. A formula can do the same inside a cell with SUBSTITUTE. Spacing and punctuation matter: “North Region” is not the same text as “North Region” with two spaces, or “North Region,” with a comma included in the search.
Replacing phrases in a longer sentence changes the matching characters and leaves surrounding text in place. It does not rewrite the sentence for meaning or grammar. After a broad replacement, check for awkward results, changed product names, or unintended matches inside other phrases.
Handle many replacements with Power Query
When you regularly import a table and apply a list of replacements, Power Query can make the process repeatable. In Windows Excel, select a cell in the data and choose Data > From Table/Range. In the Power Query Editor, select the relevant column, then use Transform > Replace Values for a replacement. Repeat that step for each term; the applied steps are recorded and can run again when you refresh the query.
Power Query is especially useful when the source file is refreshed periodically or when you want to keep a clear sequence of cleaning steps. It does not silently alter the original source table: it produces a query result that can be loaded back into Excel. Check the data types and the final output, and remember that the replacement steps apply to the selected column unless you choose a different scope. Menu labels may vary slightly across Excel builds and platforms.
Common problems and how to avoid them
- Replacing too much: A short term may appear inside other words. Test a replacement on a small selection or use Replace before Replace All.
- Changing formulas rather than displayed values: In Find and Replace, check “Look in.” Searching formulas may find text in a formula’s contents rather than the value shown in the cell.
- Searching the wrong scope: Check the selected range and the “Within” setting. A workbook-wide replacement can affect sheets you did not mean to change.
- Unexpected capitalization: Find and Replace’s case option and SUBSTITUTE’s case-sensitive behavior are not identical. Choose the method that matches your requirement.
- Overlapping replacements: Replacing a short term before a longer one can modify text that the next step was supposed to find. Put longer or more specific terms first and verify the result.
Before a large Replace All operation, save a copy of the workbook or test on a duplicate sheet. Excel’s Undo can often reverse a direct replacement, but a saved checkpoint makes recovery easier if you continue editing afterward.
Which method should you choose?
Use Find and Replace when you need to make a one-time edit and want the cells changed directly. Use a nested SUBSTITUTE formula when you want a visible, repeatable result beside the original data and have a short list of exact text substitutions. Use Power Query when the same cleanup needs to run again on imported data. For a very large or changing replacement list, a table-driven or scripted solution may be more maintainable than a long formula, but it should be tested carefully against representative data.
Before choosing, consider whether capitalization matters, whether matches inside longer words are acceptable, and whether the change should apply to one selection, one sheet, or the whole workbook. These details often matter more than the number of terms.
Frequently Asked Questions
Can Excel replace multiple words at once?
Excel’s standard Find and Replace dialog searches for one term per operation. You can run Replace All repeatedly for different terms, or use a formula or Power Query workflow to apply multiple substitutions to text.
How do I replace two words in one cell?
Use nested SUBSTITUTE functions in a neighboring cell, with the original cell as the first argument and each search-and-replacement pair inside the next function. Review the output before replacing the source values.
Does Replace All change every sheet?
Not necessarily. The “Within” setting determines whether Excel searches the current sheet or the workbook. A selected range can also limit where changes are made. Check both settings before using Replace All.
Can I replace a word without changing it inside other words?
Find and Replace does not provide a general whole-word-only option for text embedded in cells. “Match entire cell contents” applies only when the whole cell equals the search term. Test the results or use a method tailored to the text format.
Is SUBSTITUTE case-sensitive?
Yes. SUBSTITUTE matches capitalization exactly. Find and Replace can be configured with its “Match case” option, so check that setting if capitalization affects the intended result.
Related
- Excel Middle Value Extraction: Find the Median
- Excel Middle Years Academy: What Families Should Know
- Excel Middle Row Selection: Find and Select the Center Row
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Years Between Dates: Exact or DecimalFor completed years between two dates in Microsoft Excel, enter a start date in A2 and an end…
- Excel MIN With Criteria: Formulas, Examples, and FixesTo find the smallest value in Excel that meets a condition, use MINIFS: =MINIFS(B2:B10,A2:A10,"East"). It returns the minimum…
- PROPER Function in Excel: Examples and TipsExcel’s PROPER function capitalizes the first letter of each word and changes the remaining letters to lowercase. For…
- Excel IF SUM: How to Combine IF, SUMIF, and SUMIFS FormulasTo test a total and return one result or another, combine IF with SUM: for example, with amounts…
- Excel IFS Default Value: Set a Reliable Fallback ResultExcel’s IFS function has no built-in default argument: if none of its tests is TRUE, it returns #N/A.…
- Sort Excel Column Without a Header Safely in ExcelTo sort an Excel column that has no header, select the data cells, then choose Data > Sort…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.