Similar to the SEARCH function, the FIND function also locates the position of a substring within a string. However, unlike the SEARCH function, the FIND function is case-sensitive, meaning it distinguishes between uppercase and lowercase letters when searching for the exact text.
The syntax for the FIND function is:
=FIND(find_text; within_text; [start_num])
- find_text: The text or substring you want to find.
- within_text: The text in which you want to search for the substring.
- start_num (optional): The position in the text where the search should begin. If omitted, the search starts from the first character.
Practical Example of the FIND Function
Example 1:
Find the position of « GROWTH » in cell B2 in the table below.
- Go to cell C2 and type:
=FIND(« GROWTH »; B2; 1) - Press Enter.
The position of « GROWTH » in cell B2 is 22.