Functions
FIND
Case-sensitive position search
Try it
When to use it
When should I use FIND instead of SEARCH?
Use FIND for a case-sensitive match that does not allow wildcards; use SEARCH when you want a case-insensitive match or wildcard support.
What does FIND return if the text is not present?
FIND returns a #VALUE! error when the search text is not found, so wrap it in IFERROR if a missing match is expected.
Use cases
Find the position of the @ in an email address
Find a letter inside a short string
Used in
operations · retail · sales
Syntax
FIND(find_text, within_text, start)Examples
=FIND("n","printing") // => 4
=FIND("wood","How much wood can a woodchuck chuck",14) // => 21
=FIND("H","Hello World") // => 1