Find and Replace Information

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:

1. On the Home tab, in the Editing group, click on the Find & Select icon.
   
2. The Find dialog box appears. Select Replace.
3. Select the range of cells you want to search. To search the entire sheet, click any cell.
• In the Find what box, enter the text or numbers you want to search for.
• In the Replace with box, type the information that you want to substitute.
• 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. 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.