Replace Text in a Microsoft Excel Workbook: Excel MOOC
Microsoft Excel Massive Open Online Course
http://excelmooc.com/course/watch-Rep...
With Excel's Replace feature, you can quickly and easily substitute one bit of text with another throughout a workbook. Do you need to replace a word or part of a word with some other text? If you have several instances to replace, you can save time and do a more accurate job if you let Excel's Replace feature substitute the text for you.
Click in Search in Sheet icon.
Click in Replace.
The Find and Replace dialog box appears.
Click in the Find what text box and type the text you want to find.
In the Replace with text box, type the text you want to use as the replacement.
Click Find Next.
Excel selects the next cell that contains an instance of the search text.
If the search text does not exist in the document, Excel displays a dialog box to let you know.
If the selected instance is not the one you want, click Find Next until Excel finds the correct instance.
Click Replace.
Excel replaces the selected text with the replacement text.
Excel selects the next instance of the search text.
Click Close to close the Find and Replace dialog box.