Microsoft® Office Excel® 2007 Plain & Simple

Finding and Replacing Text

After you’ve entered data into a workbook, you might need to search the document for a particular word or, if one of your suppliers changes the name of a product, replace some or all instances of a word or phrase. You can do just that using Find and Replace in Excel.

Find a Word or Value

1. Click the Home tab.

2. In the Editing group, click Find and Select.

3. Click Find.

4. Type the text you want to find.

5. Click Find Next.

6. Click Close. ...