The FIND function in Excel is used to locate the position of a specific character or substring within a text string. It is case-sensitive and returns the starting position of the substring.

Syntax:

FIND(find_text, within_text, [start_num])

• find_text: The substring you want to find.
• within_text: The text string in which to search for the substring.
• start_num (optional): The position in the text string to start the search. If omitted, the search starts at the beginning.

Example 1:

=FIND("n", "OpenAI")

This formula returns 4, because “n” is the 4th character in “OpenAI”.

Example 2:

=FIND("AI", "OpenAI", 3)

This formula returns 5, because “AI” starts at the 5th character when searching from the 3rd position.

Notes:

• If the substring is not found, the function returns a #VALUE! error.
• The FIND function is case-sensitive. Use SEARCH if you need a case-insensitive search.