Excel SEARCH() Function

The SEARCH() function in excel finds one text value within another. It is the same, unlike FIND() function, with the only difference that it in a case-insensitive function.

Syntax

SEARCH (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 a corresponding Text cell

Text Result Formula
Laptop restarted 9 =SEARCH("E",A22,1)
Excel is wow! 4 =SEARCH("E",A23,1)
Superstore is closed 4 =SEARCH("E",A24,1)
90 Employees 10 =SEARCH("E",A25,1)

Example 2

Objective: Extract the last name from the given cell without entering a number of characters manually

Text Result Formula
Rohan Malhotra Malhotra =RIGHT(E99,LEN(E99)-SEARCH(" ",E99))



ADVERTISEMENT
ADVERTISEMENT