FIND

Definition: FIND is a function that searches for a specified text string within another text string, and returns the starting position of the first occurrence.

Syntax: =FIND(find_text, within_text, [start_num])

Situation: This formula is suitable when you need to search for a specified text string within another text string.

Example: If you have a text string “apple” and want to find the starting position of the letter “p”, the formula =FIND(“p”, “apple”) can be used, which returns 2.