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)



ADVERTISEMENT
ADVERTISEMENT