FUNCTION CATALOGUE / TEXT
SEARCH Excel function
Finds text without case sensitivity.
Correct sentence to use
Find [search text] inside [text], ignoring case.
Modify this query in PlainFormula →Example formula
=SEARCH("london",A2)
Returns the position of a matching string.
Syntax
SEARCH(find_text, within_text, [start_num])
Argument signature: find_text, within_text, [start_num]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.