Find and Replace
Use the Replace command to find instances of words or numbers within a worksheet and replace them with other words or numbers. To use the Replace command:
- On the HOME tab, in the Editing group, click the Find & Select
command and then select Replace:
- In the Find and Replace dialog box that appears, enter both the word or number you wish to find and the word or number you wish to replace it with.
Replace to replace the highlighted selection.
Replace All to replace all search results with the new text.
Find Next to leave the highlighted selection as is and highlight the next search result.
Find All to see a list of the instances of the word or number in your worksheet.
Close to discontinue the search.