In Excel, the Search function returns the location of a substring in a string.
The search is NOT case-sensitive.
The syntax for the Search function is:
Search( text1, text2, start_position )
text1 is the substring to search for in text2.
text2 is the string to search.
start_position is the position in text1 where the search will start.
The first position is 1.
If the Search function does not find a match, it will return a #VALUE! error.
