Open the Edit menu and select Replace. The Find and Replace dialog box opens with the Replace tab displayed.
In the Find What text box, type the data you want to find. Press the Tab key to move the cursor to the Replace with text box, and type the replacement data.
Click Replace All to replace all instances. (Or, click Find Next to find the first instance of the data, and then click Replace to replace it; repeat as necessary.)
Excel notifies you of the number of replacements it made; click OK. When you're finished using the Find and Replace dialog box, click its Close button to close it.
INTRODUCTION
Perhaps you've misspelled a company's name in your worksheet or that a person you reference in several cells has gotten married and changed her name. Fortunately, Excel enables you to search for instances of incorrect or outdated data and replace it with new data using the Find and Replace feature.
TIP
Narrowing Search Criteria
Click the Options button on the Find and Replace dialog box to make your search criteria more specific. To conduct a case-sensitive search (for example, finding all instances of Green but not green), select the Match Case option. Select Match Entire Cell Contents to limit your search to cells that contain no more and no less than the data you type (for example, to find all instances of Green but not Greenwood).