Tutorial for Excel 2010
We can use find feature of Excel 2010 e to quickly find specific text. We also can use Excel's replace feature to quickly find specific text and replace it with other texts.Find:
To quickly find specific text, execute the following steps.
On the Home tab, click Find & Select, Find
 |
| Excel 2010 Tutorial |
The 'Find and Replace' dialog box appears.
Type the text you want to find. For example, type Brown.
Click on Find Next.
Excel selects the first occurrence of the specific text.
Click on 'Find Next' if this is not the record you are looking for.
Excel selects the second occurrence of the specific text.
To get a list of all the occurrences of the specific text, click on 'Find All' in the dialog box.
Replace:
To quickly find specific text and replace it with other text, execute the following steps.
On the Home tab, click Find & Select, Replace.
The 'Find and Replace' dialog box appears (with the Replace tab selected).
Type the text you want to find (Brown) and replace it with (Brownhill).
Click on Find Next.
Excel selects the first occurrence of the specific text. No replacement has been made yet.
Click on 'Replace' if you want to make a single replacement of an occurrence.
Click on 'Replace all' to replace all occurrences of the text.
Did you find this information helpful? Show your appreciation, vote for us.
