You're probably 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 need to 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 by rows or by columns. Deselect the Find Entire Cells Only option if what you're searching for may be only part of what's in a cell. Click Find Next, and Excel will find the first instance of the text for which you're searching. Click Replace All to change all references at once, or click Replace to select each occurrence individually.