Find and Replace

Contact Us or call 1-877-932-8228
Find and Replace

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:

  1. On the HOME tab, in the Editing group, click the Find & Select command and then select Replace:Select Replace Under Find and Select Command
  2. 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.
  3. Click:
    1. Replace to replace the highlighted selection.
    2. Replace All to replace all search results with the new text.
    3. Find Next to leave the highlighted selection as is and highlight the next search result.
    4. Find All to see a list of the instances of the word or number in your worksheet.
    5. Close to discontinue the search. Find and Replace Search Box
Next