Find any word or phrase in Excel

Did you ever try to find a text desperately but could not remember where it was written? The search function and replacement is very powerful.

Pressing CTRL F will open this window.

find and replace

This allows you to find any word or phrase.

The option part allows you to define exactly where you want to look for. In a text, or in a formulas, etc...

find and replace



 

Replace

By clicking replace,  the previous window expands and becomes

 replace window

So you can easily find and replace words and sentences.

Here again, the Option gives you much more possibilities to find and replace exactly what you want.

replace option