Finding and Replacing Data in a Spreadsheet

To find and replace data in a spreadsheet:

1. Select the column or cell you want to search in.
2. In the Database Manager, in Ribbon view, on the Home tab, in the Edit group, click Replace.

- Or -

In Classic view, on the Edit menu, click Replace.

The Replace dialog box appears.

3. In the Find What field, enter the text you want replaced.
4. In the Replace With field, enter the replacement string.
5. To do a case sensitive search, select the Match Case check box. Otherwise, clear it.
6. To locate only whole words that match the search string, select the Match Whole Words Only check box. Clear the check box to locate partial words.
7. To replace text in the current selection, click the Selection option button. Or, to replace text in the selected column, click the Entire Column option button.
8. Click Find Next to locate the first occurrence of the search string in the selected column.
9. Click Replace to replace the text.
10. Repeat steps 7 and 8 to locate and replace subsequent occurrences of the search string.