FIND
Finds one text string within another (case-sensitive)
Syntax
FIND(find_text, within_text, [start_num])
Parameters
- find_text: Required. The text you want to find
- within_text: Required. The text containing the text you want to find
- start_num: Optional. The character at which to start the search (default 1)
Example
=FIND("M", "Miriam McGovern")