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)) |