Excel FIND() Function
The FIND() function in excel finds one text value within another. It is a case-sensitive function.
Syntax
FIND (find_text, within_text, [start_num])
Parameter
find_text (required)- This parameter represents the text to find.
within_text (required)- This parameter represents the text to search within.
start_num (optional)- This parameter represents the starting position in the text to search. The default value is 1.
Category
Text
Return
This function returns a number representing the location of ‘find_text’ parameter.
Example 1
Objective: Find the position of first small "e" in corresponding Text cell
Text | Result | Formula |
Laptop restarted | 9 | =FIND("e",A22,1) |
Excel is wow! | 4 | =FIND("e",A23,1) |
Superstore is closed | 4 | =FIND("e",A24,1) |
90 Employees | 10 | =FIND("e",A25,1) |
Example 2
Objective: Find out the 2nd occurrence of space” “ in corresponding cell
Text | Result | Formula |
Ritu Sinha Bhist | 11 | =FIND(" ",E93,FIND(" ",E93)+1) |