Find and Replace Text
The Find & Replace feature searches for text (or numbers or a formula). This option allows for review and/or automatic data replacement.
To use the find & replace feature:
On the Home tab, in the Editing group, click on the Find & Select icon.
The Find dialog box appears. Select Replace.
Select the range of cells you want to search. To search the entire sheet, click any cell.
1. In the Find what box, enter the text or numbers you want to search for.
2. In the Replace with box, type the information that you want to substitute.
3. Select other options as appropriate by clicking the Options button:
- Search by rows or columns.
- Match the case.
- Find entire cells only.
4. Click Find Next. The Tool will search, and if it finds a match to the criteria you entered, it will highlight that cell on the worksheet.
5. When you find the specified information, select the appropriate response:
- Replace All - Replace all occurrences of the original information with the specified data.
- Replace - Replace the original information with the specified data.
- Find All - Finds all occurrence of the information.
- Find Next - Find the next occurrence of the information
- Close - Close the Find / Replace dialog box.
Note: To cancel a search in progress, press the ESC key.
EXCEL EXTRAS
If you simply want to find specified information, and do not need to make a change, use the Find feature.