FIND & SELECT
You can use Excel's Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel's Go To Special feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc.
To quickly find specific text, execute the following steps.
1. On the Home tab, in the Editing group, click Find & Select.
2. Click Find
The 'Find and Replace' dialog box appears.
3. Type the text you want to find. For example, type Ferrari.
4. Click 'Find Next'.
Excel selects the first occurrence.
6. To get a list of all the occurrences, click 'Find All'.
The 'Find and Replace' dialog box appears (with the Replace tab selected).
Type the text you want to find (Veneno) and replace it with (Diablo).