Find & Replace - full text searches and replacing

To perform full-text searching use the Edit > Find (F3) command and in the Find field of the displayed Find & Replace toolbar specify the data to search for. Clicking the Options button you can specify how the searched data should be treated: as a regular expression or as plain text string.

Selecting a range of cells limits the searching and replacing procedure to that range. Clicking a worksheet (any cell) invalidates the active search range and searching is performed within the whole worksheet till a new selection is made.
Changing search/replace options or text strings also initiates a new search with the current (new) selection.

Searching is performed as follows:

There are three search modes that can be specified using the Options button menu: