SEARCH

Like FIND, but ignores case and accepts wildcards.

Syntax

SEARCH(find_text, within_text, [start_num])

Text Functions.

A worked example

=SEARCH("bell",A2)

Returns 8

Finds Bell at position 8 regardless of casing, where FIND would have errored.

Where it goes wrong

Like FIND, it errors rather than returning 0 when there is no match.

Learn these first