Microsoft Office Tutorials and References
In Depth Information
Replace Cell Contents
Type the text you want to search for.
Type the text you want to substitute.
Click Find Next to begin the search, and then select the next instance of the
Click Replace to substitute the replacement text, or click Replace All to sub-
stitute text throughout the entire worksheet.
You can click Find Next to locate the next instance of the cell content without
making a replacement.