SEARCH Function

Freebeginner 15 min4 tasks0/66 pts

SEARCH works like FIND but ignores case and understands the wildcards ? (one character) and * (any characters). Wrapped in ISNUMBER, it answers "does this text contain...?".

Syntax

SEARCH(find_text, within_text, [start_num])

Example: =SEARCH("shirt","BLUE SHIRT") returns 6. =ISNUMBER(SEARCH("shirt",A2)) is TRUE or FALSE.

Common mistakes

Using FIND when the capitalisation is inconsistent.
Forgetting that a missing match gives #VALUE!, so test with ISNUMBER.

FIND Function CONCAT Function