Replacing is a lot like finding; it finds the specified text. But as an extra bonus, it replaces the found text with text that you specify. For instance, if you found that you misspelled a brand name in your inventory you could replace the word with the correct spelling. Or, in our dog kennel example, you could find the dog named Sheldon and change his name to Sherman, if his new owners changed his name.
To find and replace data, follow these steps:
Select Edit, Replace or press Ctrl+H. The Replace dialog box appears (see figure 17.3).
Type the text you want to find in the Find What text box.
Type the text you want to replace it with in the Replace With text box.
Select any options you want, as you learned to do with ...