The Edit Replace command lets you quickly locate and replace numbers , text, data formats, and special characters . Suppose you have text that you entered incorrectly or that has changed throughout a large worksheet. You can use the Edit Replace command to have Excel search for and replace all occurrences of the incorrect information with the correct information. You can find and replace data in three ways:
In the next To Do exercise, you search for the first instance of the word cover and replace it with the word volume . To Do: Replace Data
If you want to specify how to find the data, click the Options button. You can search within a sheet or workbook, search by rows or columns , select a worksheet element such as Formulas, distinguish to match upper- and lowercase, and find only cells with the exact characters in Find What text box. Figure 8.14 shows the search options for finding data you want to replace. Figure 8.14. The Find and Replace dialog box with the Find options on the Replace tab.
|