Excel FIND Function Generator

Locate the position of a substring within a text string.

The substring or character you want to locate. Must be enclosed in double quotes if hardcoded (e.g., "apple").
The text string or cell reference within which you want to search for the find_text (e.g., "I love apples" or A1).
Specifies the position in within_text where the search should begin (e.g., 1 for the first character). If omitted, it defaults to 1.
Generated Formula:

Examples of FIND Function

Scenario Formula Result
Find the position of "m" in "Mango" =FIND("m", "Mango") #VALUE!
position of "M" in "Mango" =FIND("M", "Mango") 1
Find "e" in "Elephant" starting from position 3 =FIND("e", "Elephant", 3) 3
Position of "Find" in "This is Excel Find" =FIND("Find", "This is Excel Find") 15
Find position of "o" in "Hello World" - First occurrence =FIND("o", "Hello World") 5
Check if "@" exists in an email - FIND with IF =IF(ISNUMBER(FIND("@", A1)), "Valid Email", "Invalid Email")