SEARCH
Finds one text string within another (case-insensitive), supports wildcards
Syntax
SEARCH(find_text, within_text, [start_num])
Parameters
- find_text: Required. The text you want to find. You can use the ? and * wildcard characters
- within_text: Required. The text in which you want to search for find_text
- start_num: Optional. The character number in within_text at which to start searching (default 1)
Example
=SEARCH("e", "Statements", 6)