To find text in Excel and remove it, press Ctrl+H, enter the text in Find what, leave Replace with blank, and choose Replace All. That removes the matching text from cells without deleting the cells themselves; if you mean to clear whole cells or delete entire rows, use a different method.
What “delete text” means in Excel
Excel separates a cell’s contents from the cell itself. Replacing a word with nothing edits the contents but leaves the cell, its formatting, and its position in the worksheet intact. Clearing a cell removes its contents while leaving the cell in place. Deleting a cell or row changes the worksheet structure and can shift other data.
Choose the operation that matches what you want to keep:
- Remove one word or phrase from many cells: use Find and Replace.
- Empty cells that contain a matching value: find the matches, select them, and clear their contents.
- Remove records that match a condition: filter the table and delete the corresponding rows.
This distinction matters. For example, replacing “old” with nothing in “North-old” produces “North-”; clearing the cell makes it empty; deleting its row removes the entire record. If you only want the word gone, Replace All is usually the quickest choice.
Remove matching text with Find and Replace
In Excel for Microsoft 365 on Windows, use these steps to remove every occurrence of a text string from the current sheet:
- Press Ctrl+H to open the Replace tab of Find and Replace.
- Type the characters to remove in Find what.
- Leave Replace with empty. Do not type a space; a space is a character, not an empty replacement.
- Select Options if you need to set the search scope or matching rules.
- Choose Replace All. Read the confirmation message, which reports how many replacements were made, then inspect the affected cells.
For example, if cells contain “Blue team – draft” and you search for “ – draft”, replacing it with nothing leaves “Blue team”. Searching for “draft” instead leaves “Blue team – ”, including the trailing punctuation and space. Include adjacent spaces or punctuation in the Find what text when they should disappear too.
Replace All changes every match in the selected search scope, so use Find Next and Replace first if you want to review results individually. If the change is wrong, press Ctrl+Z immediately to undo it, provided you have not performed another action that prevents the undo.
Set the search scope and matching rules
The Options area controls what Excel searches. The default is generally the current sheet, but you can choose Workbook in the Within list to search across worksheets. A workbook-wide replacement can affect sheets you are not viewing, so check the scope before selecting Replace All. You can also select a range before opening Find and Replace to limit the operation; verify the range and results rather than assuming the whole workbook is intended.
The Match case option makes uppercase and lowercase matter. With it off, a search for “draft” can match “Draft”; with it on, those spellings are treated differently. Match entire cell contents limits matches to cells whose entire content is exactly the search text. Leave that option off when removing a word from a longer phrase.
Use the Look in setting thoughtfully. Searching values is useful when you are looking for displayed cell content. Searching formulas looks at formula text; replacing text in formulas can change the formulas themselves, not merely what they display. For cells whose text is generated by formulas, edit the formula or use a helper formula rather than trying to erase the displayed result.
Clear matching cells without deleting rows
If you want to empty whole cells containing a word, rather than remove just that word, use Find All to identify the matches. Press Ctrl+F, enter the text, and choose Find All. In the results list, select the matches you intend to clear; when selecting all results, check that the search scope is correct. Close the dialog without clicking a different worksheet cell, so the found cells remain selected, then press Delete. This clears cell contents but does not remove formatting or shift neighboring cells.
Check a few selected cells before pressing Delete, especially if the text may occur inside longer entries. A search for “late” could match both “late” and “lately.” If only exact cell values qualify, enable Match entire cell contents before finding them. If the workbook contains formulas, clearing a formula cell removes the formula as well as its displayed result.
On Windows, the Delete key clears the contents of selected cells; it is not the same as choosing Home > Delete > Delete Cells, which opens options that can shift surrounding cells. On Excel for Mac, use the Find controls on the Home tab or the version’s Edit > Find menu, then clear the selected cells with the Delete key. Menu names and shortcut behavior can vary by Mac release.
Delete rows that contain the text
When the matching text identifies records you want to remove, delete the full rows rather than only clearing the matching cells. First make a copy of the workbook or table. Then apply a filter to the relevant column using Data > Filter. Open the column’s filter menu and use its text-filter options, such as Text Filters > Contains, to show rows with the target text.
Review the visible records carefully. A contains condition can match longer words as well as the exact term, and deleting a row removes every value in that record, not just the text in the filtered column. Select the visible row headers for the records you intend to remove, delete the sheet rows, and then clear the filter to check the remaining data. Avoid selecting the entire worksheet column and deleting it unless removing that column is actually the goal.
For a one-time cleanup, a filter is often easier to audit than selecting scattered search results. In a structured Excel table, filtering also makes it easier to see which records meet the condition before you remove them. If other worksheets contain formulas that refer to deleted rows, review those formulas afterward; deleting rows can affect references and totals.
Remove text with a formula instead
A formula is a useful alternative when you want to preserve the original data, preview the cleanup, or apply the same rule to a column. With the original text in A2, enter this in B2:
=SUBSTITUTE(A2,"draft","")
If A2 contains “Blue draft label draft”, the result is “Blue label ”: SUBSTITUTE removes every occurrence of the specified text, while the spaces around each occurrence remain. The function is case-sensitive, so this formula removes lowercase “draft” but does not remove “Draft”. Fill the formula down to process other rows, review the results, and, if appropriate, copy the results and use Paste Special > Values to replace the original entries with fixed text. Keep the source column until you have checked the output.
Unlike Find and Replace, a formula leaves the source cells unchanged until you choose to replace them. It also makes the rule visible and repeatable. But the result is formula output, not an edited original value; if the source changes, the result can change too. Do not use SUBSTITUTE on a column of formulas if you mean to change what those formulas calculate—edit the formulas themselves instead.
Common problems and safe checks
- Nothing was found: check for extra spaces, punctuation, spelling, case settings, and whether the search is limited to one sheet or selection. A normal space and a nonbreaking space can look alike but are different characters.
- Too much text disappeared: undo immediately, narrow the range, or use Find Next and Replace to review matches. A short search term may appear inside many unrelated words.
- Spaces or punctuation remain: search for the adjacent characters too, such as a leading space before a word. Check the output before running another broad replacement.
- Formulas changed or results did not: inspect the Look in setting and the cell contents. Formula-generated text is not an independent typed value; changing the formula is usually the appropriate fix.
- Search characters act like patterns: Find and Replace supports wildcard searches. The asterisk (*) can stand for a sequence of characters and the question mark (?) for one character. To search for a literal wildcard character, prefix it with a tilde, such as ~* for an actual asterisk.
For a large or important workbook, save a separate copy before a bulk replacement or row deletion. Find and Replace is easy to run across a broad scope, and a replacement can alter labels, formulas, or data you did not intend to touch. A quick review of the scope, a test on a small range, and a check of the replacement count are practical safeguards.
Frequently Asked Questions
How do I delete only part of the text in an Excel cell?
Press Ctrl+H, enter the specific characters in Find what, leave Replace with empty, and select Replace All. Use Find Next first if you need to inspect matches individually.
How do I remove a word from every sheet in a workbook?
Open Find and Replace, select Options, set Within to Workbook, enter the word, and leave Replace with blank. Check the workbook-wide scope and the replacement count before relying on the result.
Does replacing text with a blank delete the cell?
No. It removes the matching characters from the cell’s contents. The cell remains in place, and its formatting is generally left intact. To empty the entire cell, select it and clear its contents; to remove the record, delete its row.
Can Excel find and remove text inside a formula?
Find and Replace can search formula text, but replacing it may change the formula. If a formula displays the text you want gone, edit the formula that produces the result or build a cleaned result in a separate cell.
How can I remove a word but keep the rest of the cell?
Use Find and Replace with the word as the search text and an empty replacement. Include a neighboring space if you do not want that space left behind, and check whether the word appears as part of other terms.
Can I undo Replace All?
Usually, Ctrl+Z on Windows reverses the most recent replacement if it is still the latest undoable action. For important data, save a copy first and verify the results before continuing with other edits.
Related
- Excel File Too Large for No Reason? Find the Hidden Data
- Excel File Size Too Large? How to Reduce It
- Excel File Large for No Reason? Causes and Fixes to Try
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Hide a Column in a Power BI Table: Options ExplainedYes, but the right method depends on what you mean by “hide.” To remove a column from one…
- How to Split Merged Cells in Google Sheets SafelyTo split merged cells in Google Sheets, select a merged cell, then choose Format > Merge cells >…
- Merge Cells in Excel: Steps, Options, and TipsTo merge cells in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Merge…
- Excel Merge Cells Shortcut: Keys and TipsIn Excel for Microsoft 365 on Windows, select the cells and press Alt, H, M, C in sequence…
- Excel Flash Fill: How to Disable Automatic SuggestionsTo disable automatic Flash Fill in Excel for Microsoft 365 on Windows, go to File > Options >…
- How to Add Reference Footnotes in Word, Step by StepTo add a reference footnote in Word, place the cursor after the passage you are citing, choose References…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.