Microsoft Office Tutorials and References
In Depth Information
Replace Text in a Workbook
Dealing with Workbooks
A Excel selects the cell that
contains the next instance of
the search text.
Note: If the search text does
not exist in the document, Excel
displays a dialog box to let you
7 If the selected instance is not
the one you want, click Find
Next until Excel finds the
8 Click Replace .
B Excel replaces the selected
text with the replacement text.
C Excel selects the next instance
of the search text.
9 Repeat Steps and until you 8
have replaced all of the
instances you want to replace.
0 Click Close to close the Find
and Replace dialog box.
Is there a faster way to replace every instance of the search text with the replacement text?
Yes. In the Find and Replace dialog box, click Replace All . This tells Excel to replace every
instance of the search text with the replacement text. However, you should exercise some
caution with this feature because it may make some replacements that you did not intend.
Click Find Next a few times to make sure the matches are correct. Also, consider clicking
Options and then selecting the Match case check box (
), as described in the
previous section, “Find Text in a Workbook.”