TEXT: Replace

Description

Searches for and replaces a string in the grid. Note that cells in fixed rows and columns are not included in searches. Also, text in read-only cells cannot be replaced.

Searching is based on a number of options. These options are saved between searches.

An information box is given if no match, or no further matches, can be found.

To repeat a previous search and replace, use Find Again (F3 key).

Dialog

Find

The text to be found and replaced.

Previous search strings are stored in the dropdown list for subsequent retrieval.

Replace with

The text to replace the found text.

Previous replace strings are stored in the dropdown list for subsequent retrieval.

Direction

Forward

Searches towards the last cell in the grid.
Backward

Searches towards the first cell in the grid.

Origin

From cursor

Search begins with the focused cell.
Entire text

Search begins with the first cell in the grid (if search direction is forward), or the last cell in the grid (if search direction is backward).

Find using...

Partial string

Searches for cells containing the search string embedded within their contents. For example, 2.3 is matched by 12.356.
Exact string

Searches for cells containing an exact string match.
Number value

Converts the search string to a number and searches for cells containing this number. For example, 1000 is matched by 10E+3.

Options

Current column only

If set, searches for cells in the active column only.
Prompt on replace

If set, requests confirmation before replacing an instance of the search string.

Replace All

Replaces this instance, and all further instances of the search string.