Excel: Replace words - with these tricks it works

With the "Find" and "Replace" functions, you can search Microsoft Excel workbooks or worksheets for specific text strings or numbers and replace them with new content if necessary.

Search your workbook for words: here's how

Use the Search function to search your workbook in Excel for a specific item based on criteria you specify. Search results can then be replaced using the Replace function.

1. Start Excel and open a document in which you want to search for content to replace.
2. Call the Find and Replace dialog by pressing [Ctrl] + [F].
3. Enter a word you want to search for in "Search for".
4. Click the "Options" button to specify the search criteria.
5. Limit the search range using the "Browse", "Search" and "Search in" items.
6. Also specify whether Excel is case-sensitive and whether the search should be compared to the entire cell contents.
7. Finally click on "All searches".

The search results will then be displayed as a list.

Replace search results

You can now replace your search results with new content.

1. Switch to the "Replace" tab.
2. Input a new content at "Replace with" with which you want to replace the searched word.
3. Select only certain search results you want to replace and click "Replace" or replace all results by clicking "Replace all".