Search and Replace

Youre likely familiar with the search and replace feature in your word processing application. This feature finds every instance of a particular word or phrase and replaces it with another word or phrase. Excel can also support this feature. If you misspell a name or must update a frequently used reference, use Search and Replace.
First, select Edit, Replace. In the Replace dialog box, enter the text you want to replace in the Find What text box. In the Replace With text box, enter the replacement text. Next, from the Search drop-down list, tell Excel whether you want to search through rows or through columns.
Deselect the Find Entire Cells Only option if what youre browsing for may be only segment of whats in a cell. Click Find Next, as well as Excel will get the first instance of the text for which youre searching. Click Replace All to change all references at once, or click Replace to select each occurrence individually.