Remove a Word in an Excel Cell With Find & Replace

How-to basics · Updated November 20, 2026

To remove a word from an Excel cell, select the cell or range, press Ctrl+H, enter the word in Find what, leave Replace with blank, and choose Replace or Replace All. This quick method can also remove that sequence of letters from larger words, so check your data first. For a more precise removal of a space-separated whole word, use the formula method below. Make a copy of important data before changing it; Find and Replace changes cell contents directly.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the workbook containing the text you want to edit.
  • The word you want to remove, including its usual capitalization and any spaces or punctuation around it.
  • A spare column if you want to use a formula and keep the original text unchanged until you have checked the result.

Find and Replace is available in Excel for Microsoft 365 and is the quickest choice for a simple replacement. The formula option uses TEXTSPLIT, FILTER, and LET, which are available in Microsoft 365 and Excel 2024. If your version does not include those functions, use Find and Replace carefully or follow the alternative advice in Troubleshooting.

Step-by-Step

  1. Decide what counts as a match. Check whether you mean the letters wherever they appear, a whole word separated by spaces, or a word with punctuation attached. For example, searching for cat will also find cat in catalog. Excel’s Find and Replace does not provide a general whole-word-only option, so the safest method depends on the text. If the target is a space-separated word and similar words must remain, use the formula steps below.
  2. Save a copy or make a test. If the workbook is important, use File > Save As to create a copy before editing. For a small change, test on one cell first. This matters especially when you plan to use Replace All, because it can update many occurrences at once and may change text you did not intend to alter.
  3. Select the cells to edit. Click one cell to search the current worksheet, or select the specific range you want to change. Selecting a range helps limit the change to those cells. If you need to edit only one cell, select that cell and confirm the correct cell is active before continuing.
  4. Open Find and Replace. Press Ctrl+H on Windows. You can also open Home > Find & Select > Replace. In the dialog, enter the target in the Find what box. For example, if the cell says The blue bike is fast and you want to remove blue, enter blue. Do not add quotation marks around the word.
  5. Leave the replacement empty. Click in Replace with and make sure it contains nothing. If there is old text in the box, select and delete it. A blank replacement tells Excel to remove the found text rather than substitute another word. Avoid entering a space unless you deliberately want to replace the word with a space.
  6. Review the search options. Expand Options if needed. Match case makes the search sensitive to uppercase and lowercase; turn it on only if capitalization matters. Match entire cell contents is not the same as whole-word matching: when enabled, it finds a match only when the whole cell equals the search text. Leave it off when the word is part of a longer sentence. Check that the Within setting is appropriate, usually Sheet for the current worksheet.
  7. Choose a cautious replacement action. Use Find Next to inspect each match, then select Replace to change that occurrence and move to the next. This is the better choice when you are unsure about similar words or punctuation. Use Replace All only after you have checked the search term, selected range, and options. Excel reports how many replacements it made; review a few changed cells afterward.
  8. Check spacing and punctuation. Replacing a word with nothing can leave two spaces, or can join the words on either side. For instance, replacing blue in The blue bike with blank may produce The bike, with a doubled space. If that happens, undo immediately with Ctrl+Z and try a replacement that accounts for the surrounding spaces, or use the formula approach. Check commas, periods, and other punctuation too.
  9. Use a formula when only a whole space-separated word should go. Keep the original sentence in A2, put the target word in B1, and enter the following formula in C2. It removes an exact, case-sensitive token separated by spaces and joins the remaining tokens with one space:
    =LET(parts,TEXTSPLIT(A2," ",,TRUE),TEXTJOIN(" ",TRUE,FILTER(parts,NOT(EXACT(parts,$B$1)),"")))
    For example, if A2 contains red blue red and B1 contains blue, C2 returns red red. If you want the target to be blue in lowercase only, this formula will not remove Blue; EXACT deliberately distinguishes case. To make the removal case-insensitive, replace EXACT(parts,$B$1) with a comparison using LOWER on both values.
  10. Review and apply formula results. Check the output in C2 before filling the formula down. If it is correct, copy C2 and fill it through the rows you need, or drag the fill handle down. When you are satisfied, copy the results and use Home > Paste > Paste Values over the original cells if you want permanent text instead of formulas. Keep the original column until you have verified the pasted results.

The formula treats spaces as separators, not punctuation. A token such as blue, with a comma attached, is not identical to blue in B1 and will remain. It also normalizes spacing in the output to single spaces. If your cells contain tabs, line breaks, hyphens, or punctuation attached to words, inspect the results and choose a method that matches those separators rather than assuming the formula recognizes every kind of word boundary.

Common Mistakes

  • Assuming Find and Replace matches whole words. Excel searches for the character sequence you enter. Searching for art can remove those letters from party or artist, depending on the text. Check for similar words before using Replace All, or use the exact-token formula for ordinary space-separated text.
  • Checking Match entire cell contents by mistake. That option limits the match to cells whose complete contents equal the search term. It will not remove a word from a sentence. It is useful only when the cell itself contains exactly the text you want to replace.
  • Leaving a space in Replace with unintentionally. A single space is not an empty replacement. It may create extra gaps or preserve a blank where you expected the word to disappear. Click the box and verify it is empty before replacing.
  • Removing a word and joining its neighbors. If the text is one two three and you remove two with no replacement spacing, the result may read one three only if spaces are handled correctly; a careless replacement can instead create onethree or an awkward double space. Inspect the result and undo if the words run together.
  • Forgetting the scope of the search. Replace All may affect more cells than expected if the selection or Within option is wrong. Verify the range and worksheet setting first. If the workbook has multiple sheets, do not assume a search limited to Sheet will include them all.
  • Overwriting the source before checking formula output. A helper formula is useful because it leaves the original intact. Do not paste results over the source until you have confirmed capitalization, punctuation, and spacing in representative rows.

Tips

  • Use Find Next as a preview. When you are not certain how often the word appears, review matches individually before deciding whether a bulk replacement is safe. A quick visual check can reveal a name, longer word, or unusual phrase that should not change.
  • Use a distinctive target. If the desired text includes a phrase rather than a single word, enter the whole phrase in Find what. This can reduce accidental matches, although Excel still searches for that exact sequence of characters and does not interpret grammar or word boundaries.
  • Keep the original data during cleanup. A helper column makes it easy to compare source and result side by side. You can filter the rows, spot exceptions, and correct the formula or target word before replacing the original values.
  • Remember that the formula is case-sensitive by design. EXACT checks the token and target with case sensitivity. This is useful when Blue and blue have different meanings in your data. If case should not matter, use LOWER for both sides in the comparison, then test examples that differ only by capitalization.
  • Expect the formula to standardize spaces. TEXTSPLIT ignores repeated spaces here, and TEXTJOIN places one space between remaining tokens. This is often helpful for clean sentences, but it will not preserve deliberate spacing or formatting conventions. Keep a source copy if the original spacing matters.
  • Use the keyboard alternative on a Mac. In Excel for Mac, the Find and Replace shortcut is usually Control+H; if that shortcut is intercepted by macOS or your keyboard settings, use Edit > Find > Replace or the Home ribbon’s Find options. Excel for the web has Find and Replace under Home > Find & Select, though shortcut behavior can depend on the browser.

Troubleshooting

Replace All reports zero changes. Confirm the spelling and spaces in Find what, and check whether Match case is enabled. If Match entire cell contents is checked, clear it when searching within sentences. Also verify that Within is set to Sheet and that you are on the intended worksheet. If the text is produced by a formula, the displayed result may be searchable, but replacing it can replace the formula with a constant; inspect the formula bar before editing those cells.

Excel changes part of another word. Undo with Ctrl+Z as soon as you notice. Find and Replace has no general whole-word boundary setting, so do not run the same broad search again with Replace All. For text separated by ordinary spaces, use the formula method and compare the output. For punctuation-attached words or inconsistent delimiters, use a carefully reviewed helper column or edit the individual cells rather than relying on a broad search.

The output contains a doubled space or joined words. Undo the replacement if it has changed the source. Decide whether the word is surrounded by spaces, at the start or end of a sentence, or next to punctuation. A simple blank replacement may leave spacing behind or remove the separator. For space-separated text, the formula creates a clean single-space result; for other formats, adjust the text carefully and inspect each edge case.

The formula returns an error or Excel shows the formula as text. Check that you are using Microsoft 365 or Excel 2024, that the formula begins with an equals sign, and that the quotes are straight quotation marks. Confirm the source is in A2 and the target is in B1, as assumed. If your Excel installation uses semicolons rather than commas as formula separators because of regional settings, replace the argument commas with the separator used by your installation. If you see a function-name error, your version may not include TEXTSPLIT, FILTER, or LET.

The formula leaves a word you expected it to remove. Check whether it is attached to punctuation, such as word, or has different capitalization from the target. The formula compares complete tokens and is case-sensitive. It also uses spaces as its delimiter, so text separated by a hyphen, tab, or line break will not be treated as the same token. Change the data carefully or use a method suited to its actual separators.

The formula removes every token and returns a blank. That is the expected result if every space-separated token in the source exactly matches the target. Check A2 and B1 for accidental extra spaces or an incorrect target. If you wanted to retain one occurrence, the formula needs a different rule; this version removes all exact matches.

Frequently Asked Questions

Can I remove a word from multiple cells at once?
Yes. Select the range before opening Ctrl+H, then use Find Next and Replace to check matches or choose Replace All after confirming the scope. For a formula workflow, fill the helper formula down alongside the rows you want to clean.

How do I remove a word without deleting it from similar words?
Find and Replace does not offer a general whole-word-only match. For text with words separated by spaces, use the formula above, which removes tokens that exactly match the target and keeps longer tokens such as catalog when the target is cat. Review punctuation-attached cases separately.

Can I remove the word but keep a space in its place?
Yes. In Find and Replace, put one space in Replace with instead of leaving it blank. This can prevent neighboring words from joining, but may create extra spaces when the target is at an edge or already has spaces around it. Check the result before applying the change widely.

Will Find and Replace change formulas?
It can change displayed text inside cells that contain formulas, and a replacement may replace a formula with a fixed value. Before making changes, select a sample cell and check the formula bar. Use a helper column or edit the formula itself if the word comes from a formula result that must remain dynamic.

Can I undo Replace All?
Usually, Ctrl+Z on Windows reverses the latest Find and Replace action. On Mac, use Command+Z. If you have made other changes since then, or saved and closed the workbook, undo may not restore the earlier state, which is why a backup or test range is useful.

Does the formula preserve punctuation and multiple spaces?
It keeps punctuation attached to tokens, but that means a token with punctuation may not match the target word. It does not preserve repeated spaces: the result is joined with single spaces. If the exact spacing or punctuation pattern must remain unchanged, review and edit a copy of the data rather than applying this formula without checking.

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.