Find and Replace in Excel

Excel's Find and Replace feature is a quick way of finding specific text and we can replace it with other text. We have to go to Special feature to quickly select all the cells with formkulas, comments, conditional formatting, constants and data validation etc. Find in Excel Follow the steps below to find text in Excel.
1. On the Home tab, in the Editing group, click Find & Select.
2. Click Find

3. The 'Find and Replace' dialog box appears.

3. Type the text you want to find. For example and when you find it
Excel selects the first occurrence.
4. Click 'Find Next'.
5. Click 'Find Next' to select the second occurrence.
6. To get a list of all the occurrences, click 'Find All'.
Replace in Excel
To quickly find specific text and replace it with other text, execute the following steps.
On the Home tab, in the Editing group, click Find & Select.

and you can replace the text you selected in find