Page 239 - Excel 2013 All-in-One For Dummies

Figure 3-17:
Updating dates in a worksheet using the Find and Replace feature.
Find and Replace This Disgrace! 221
6. Make any necessary changes to the Within, Search, Look In, Match Case, and Match Entire Cell Contents options for the search string.
These options work just as they do on the Find tab. If these options aren’t displayed on the Replace tab of your Find and Replace dialog box, click its Options button to expand the dialog box.
7. Click the Find Next button to locate the first occurrence of the search string. Then, click the Replace button to replace the first occurrence with the replacement string or click the Find Next button again to skip this occurrence.
Using the Find Next and Replace buttons to search and replace on a case-by-case basis is by far the safest way to use the Find and Replace feature. If you’re certain (really certain) that you won’t mess up anything by replacing all occurrences throughout the spreadsheet, you can click the Replace All button to have Excel make the replacements globally without stopping to show you which cells are updated.
8. When you finish replacing entries on a case-by-case basis, click the Close button.
This action abandons the Find and Replace operation and closes the Find and Replace dialog box. When you globally replace the search string, Excel automatically closes the Find and Replace dialog box after replacing the last search string match.
Remember that you can click the Undo button on the Quick Access toolbar or press Ctrl+Z to restore any replacements that you made in error.
Book II Chapter 3
Editing and Proofing Worksheets