Case Sensitive (applies to simple searches and regular expressions)
You can use the Case Sensitive option for both simple searches and regular expression searches. If this option is turned on, AdvancedSearch differentiates between lowercase and uppercase characters. If this option is turned off, AdvancedSearch ignores case differences when searching for characters.
Wildcards (applies to simple searches only)
If you are doing a simple search you can use the wildcard option. When this option is turned on, AdvancedSearch implements the standard ? and * wildcards:
? matches exactly one character (including a space)
* matches zero or more characters (including spaces)
If you want to search for literal ? and * characters when using this option, you will need to escape each character with a tilde (~). That is, you will need to use ~? and ~* to indicate literal ? and * characters respectively. Because the tilde character has a special meaning, you must use ~~ to indicate a literal ~ character when doing wildcard searches.
Examples
- +?ello
This will match any five characters ending in ello
- +~?ello
This will match the string ?ello
- +~~ello
This will match the string ~ello
Complete Cells (applies to simple searches only)
The Complete Cells option is available for simple searches only. When searching cell values, if the complete cells option is turned on, AdvancedSearch will only look for cells that are an exact match for the text being sought. In other words, AdvancedSearch will ignore any cells that contain something more than the text being sought.
This option has no effect when Formulas, Comments and Names are being searched.
Example
If the search text is +hello, AdvancedSearch will find only those cells where the value is precisely hello. Cells containing additional characters (for example, hello world) would not be matched if the complete cells option is turned on.
Regular Expression
If this option is turned on, the text string is interpreted as a regular expression.
