All functions / Text
SEARCH
Position of one text inside another (not case-sensitive, allows wildcards).
Syntax
=SEARCH(find_text, within_text, [start_num])
Arguments
find_text: What to look for. Can use * and ?.within_text: Where to look.start_num(optional): Where to start searching (default 1).
Example
=SEARCH("x", "Excel") → 2