Used to replace text in cells or formulas in the report.

FIELDS:

Find What:  Searches for any occurrence of the string in the options specified.  For example if you search for "mg" it will find cells with mg/L, conc mg/L, etc...  Searches ARE case sensitive.

Replace With:  Text that will replace the text entered in the Find What field.

Search in Cell Text: Search the text that is displayed in the cells.

Search Formulas: Searches the formulas for the string.

Search Cell Notes: Search the cell notes for the string specified.

BUTTONS:

	Searches for the first cell that contains the string and replaces it.  Starts in Cell A1 and search down and then to the right.
	Starts searching from the current cell and searchs down and to the right.
	Searches the entire spreadsheet and replaces all occurrences of the string.
	Searches the currently selected area and replaces all occurrences of the string in the area.  Only enabled when a block of cells is selected
	Closes the Find Form.

 

See Also:  Spread Find