Remove a Word from Multiple Cells in Excel
When working with a large Excel worksheet, you may sometimes need to remove the same word from multiple cells. For example, a column may contain entries such as “Apple Store”, “Microsoft Store”, and “Google Store”, and you may want to remove the word “Store” from all of them at once.
Manually editing every cell can take a lot of time, especially when your worksheet contains hundreds or thousands of rows. Fortunately, Excel provides several easy ways to remove a specific word from multiple cells without changing the rest of the data.
In this guide, you will learn how to remove a word from multiple cells in Excel using Find and Replace, formulas, Flash Fill, and other practical methods.
Remove a Word from Multiple Cells in Excel
You can remove a word from multiple cells in Excel by selecting the cells, opening Find and Replace with Ctrl + H, entering the word you want to remove in the Find what box, leaving Replace with empty, and selecting Replace All. Excel will remove the specified word from the selected cells while keeping the remaining text.
For example, if cells contain “Windows 11 Laptop”, “Windows 11 Desktop”, and “Windows 11 PC”, you can use Find and Replace to remove “Windows 11” from all selected cells at once.
Step 1: Select the Cells Containing the Word
The first step is to select the cells where you want to remove the word. Selecting the correct range is important because Excel’s Replace All command can modify many cells at once.
For example, suppose your worksheet contains product names in cells A2 through A100, and you want to remove the word “Laptop” wherever it appears. Select cells A2:A100 by clicking cell A2 and dragging down to A100.
You can also select a larger range by clicking the first cell and holding the Shift key while selecting the last cell. If the data is in a single column, you can select the entire column, but selecting only the required cells is generally safer.
Step 2: Open Find and Replace
With the cells selected, press Ctrl + H on your keyboard. This opens Excel’s Find and Replace window.
You can also open it manually by going to the Home tab on the Excel ribbon. Look for the Editing section, select Find & Select, and then choose Replace.
The Find and Replace window contains two important fields. The first is Find what, which tells Excel what you want to find. The second is Replace with, which tells Excel what should be inserted instead.
Step 3: Enter the Word You Want to Remove
Click inside the Find what box and type the exact word or text you want to remove.
For example, if your cells contain:
Dell Laptop
HP Laptop
Lenovo Laptop
and you want to remove Laptop, enter Laptop in the Find what box.
Now leave the Replace with box completely empty. An empty Replace with field tells Excel that you want to replace the matching word with nothing.
This is the key part of the process. You do not need to type a space, zero, or another character into the Replace with box.
Step 4: Use Replace All
Once you have entered the word in Find what and left Replace with empty, click Replace All.
Excel will search the selected cells and remove every matching occurrence of the specified text.
For example, if your cells originally contain:
Dell Laptop
HP Laptop
Lenovo Laptop
they will become:
Dell
HP
Lenovo
Excel will usually display a message telling you how many replacements were made. Review the result carefully to make sure the correct word was removed.
Step 5: Check the Results
After using Replace All, examine the modified cells. Make sure the intended word has been removed and that the remaining information is still correct.
If you accidentally removed something you did not intend to change, immediately press Ctrl + Z to undo the operation.
It is a good idea to save a copy of your worksheet before performing a large Replace All operation. This is particularly useful when working with important business, financial, customer, or inventory data.
Step 6: Remove Extra Spaces
Sometimes removing a word can leave an unwanted space behind.
For example, suppose a cell contains:
Microsoft Windows PC
If you remove Windows, the result may be:
Microsoft PC
There are now two spaces between Microsoft and PC.
You can often fix this by using Excel’s TRIM function or by using Find and Replace to correct the extra spaces. Checking the results after removal is therefore important, especially when the word appears in the middle of a sentence.
Remove a Word from Multiple Cells in Excel Using Formula
If you do not want to permanently change the original cells, you can use a formula to create a modified version of the data.
The most useful function for this purpose is SUBSTITUTE.
Suppose cell A2 contains:
Microsoft Windows Laptop
and you want to remove the word Windows.
In another cell, enter:
=SUBSTITUTE(A2,”Windows”,””)
Press Enter, and Excel will return:
Microsoft Laptop
The original cell remains unchanged.
If you also want to remove the extra spaces created after removing the word, use TRIM around the SUBSTITUTE function:
=TRIM(SUBSTITUTE(A2,”Windows”,””))
The result will be:
Microsoft Laptop
You can then copy the formula down to apply it to other rows.
If your data extends from A2 to A500, enter the formula in B2 and drag the fill handle downward. Excel will automatically adjust the cell references for each row.
This method is particularly useful when you want to preserve the original data and create a cleaned version in another column.
Alternative Methods
Use Flash Fill
Flash Fill can be useful when the pattern is simple and Excel can recognize what you are trying to accomplish.
Suppose A2 contains John Smith Employee and you want the result to be John Smith. In B2, manually type the desired result. Then start entering the next result in B3.
Excel may recognize the pattern and automatically suggest the remaining results. Press Enter to accept the Flash Fill suggestion.
You can also press Ctrl + E to activate Flash Fill.
This method works best when the data follows a consistent pattern. However, for simply removing the same word from many cells, Find and Replace is usually faster and more reliable.
Use Power Query
If you regularly clean large datasets, Power Query provides a more advanced solution.
Select your data and use Excel’s Data tab to load the range into Power Query. In the Power Query Editor, select the relevant column and use the Replace Values option.
Enter the word you want to remove and replace it with an empty value. When you finish cleaning the data, load the results back into Excel.
Power Query is especially useful when you receive the same type of data regularly and need to repeat the cleaning process.
Use Find and Replace on an Entire Worksheet
If you need to remove a word from the entire worksheet, you can use Ctrl + H without first selecting a small range.
Enter the unwanted word in Find what, leave Replace with empty, and select Replace All.
However, be careful with this method. Excel may remove the word from places where you wanted to keep it. For example, the same text could appear in headings, notes, formulas, or other unrelated areas.
For this reason, selecting a specific range before using Replace All is generally the safer approach.
Remove a Word Only When It Appears as a Separate Word
There is an important difference between removing a word and removing a sequence of characters.
For example, if you search for app, Excel may find that text inside words such as Apple or Application. If your intention is to remove only the separate word “app”, you need to be more careful.
Find and Replace does not always behave like a full word-boundary search tool. In such cases, a formula or more advanced data-cleaning method may be more appropriate.
FAQs
Can I remove a word from multiple Excel cells at once?
Yes. The easiest method is Find and Replace. Select the required cells, press Ctrl + H, enter the word in Find what, leave Replace with empty, and select Replace All.
Does Replace All remove the word from the original cells?
Yes. Replace All directly changes the selected cells. If you want to keep the original information, use the SUBSTITUTE formula in another column instead.
How do I remove a word and extra spaces in Excel?
Use the TRIM and SUBSTITUTE functions together. For example:
=TRIM(SUBSTITUTE(A2,”Windows”,””))
This removes the specified text and cleans up unnecessary spaces.
Can I remove multiple different words?
Yes. You can perform multiple Find and Replace operations, one word at a time. Alternatively, you can create a more advanced formula when several replacements need to happen automatically.
What happens if I remove the wrong word?
You can immediately press Ctrl + Z to undo the replacement. It is also recommended to create a backup copy before making large changes.
Can I remove a word from an entire column?
Yes. Select the column or the specific range you want to modify, open Find and Replace, enter the word, leave Replace with blank, and use Replace All.
Summary
Removing a word from multiple cells in Excel does not have to be a time-consuming task. For most beginners, the quickest solution is Find and Replace. Select the required cells, press Ctrl + H, enter the unwanted word in Find what, leave Replace with empty, and select Replace All.
If you want to keep the original data unchanged, the SUBSTITUTE formula is a better option. Combining it with TRIM can also remove unwanted spaces left behind after the replacement.
For more advanced data-cleaning tasks, Flash Fill and Power Query can be useful alternatives.
Whichever method you choose, always check the results after removing the word, especially when working with a large or important Excel worksheet.