The Excel SEARCH function returns the position of a specified character or sub-string within a supplied text string.
The function is not case-sensitive. If you want to perform a case-sensitive search, use the Excel Find function instead.
The syntax of the Search function is:
Where the function arguments are:
|search_text||-||The character or sub-string that you wish to search for.|
|within_text||-||The text string that is to be searched.|
|[start_num]||-||within_text string)If omitted, this takes on the default value of 1 (i.e. begin the search at the start of the|
You can also use the following wildcards in the search_text argument:
? - matches any single character
* - matches any sequence of characters
If the supplied search_text is found, the Search function returns a number representing its position in the within_text. If the supplied search_text is not found, the function returns the Excel #VALUE! error.
Column B of the following spreadsheet shows examples of the Excel Search function, used to search for various characters within the text string "Original Text".
Note that, in the above examples:
For further details and examples of the Excel Search function, see the Microsoft Office website.
If you get an error from the Excel Search function this is likely to be the #VALUE! error: