SEARCH

Try it

When to use it

When should I use SEARCH instead of FIND?

Use SEARCH when you want a case-insensitive match or wildcards; use FIND when the match must respect upper and lower case exactly.

Is SEARCH case-sensitive?

No — SEARCH ignores case, so searching for B will match either b or B in the text.

Use cases

Locate a keyword inside an address

Detect a term in a log line regardless of case

Used in

operations · sales

Syntax

SEARCH(find_text, within_text, [start_num])

Examples

=SEARCH("n","printing") // => 4
=SEARCH("N","printing") // => 4
=SEARCH("a","banana",3) // => 4