The Find/Replace dialog helps you to search for text in a formula or function, and replace the found text with different text. It appears when you select Menu > Edit > Search in the Formula Editor or User Defined Function Editor.
The following are details about options in the dialog:
Specifies what to find.
Specifies what to use to replace the found text.
Specifies the finding limit.
- Match case
Limits the search to text that exactly matches the case of the text you want to find.
- Match whole word
Limits the search to text that matches one or more complete words.
Jumps to and selects the next occurrence of the search words in the formula/function text.
Finds all occurrences of the search words in the formula/function text.
Replaces the found material one by one in the formula/function text.
Replaces all of the found materials in the formula/function text.
Closes the dialog.
Please sign in to leave a comment.