Tweet
The Excel SEARCH function returns the position of a specified character or string within a supplied text string. The function is not case-sensitive.
The function is case-sensitive. If you want to perform a case-sensitive search, use the Excel Find function instead.The syntax of the Search function is :
The function is case-sensitive. If you want to perform a case-sensitive search, use the Excel Find function instead.The syntax of the Search function is :
SEARCH( search_text, within_text, [start_num] )
Where the function arguments are:
search_text - The character or text string that you wish to search for
within_text - The text string that is to be searched
[start_num] - An optional argument that specifies the position of the character from which the search should begin
If omitted, this takes on the default value of 1 (i.e. begin the search at the start of the within_text string)
Where the function arguments are:
search_text - The character or text string that you wish to search for
within_text - The text string that is to be searched
[start_num] - An optional argument that specifies the position of the character from which the search should begin
If omitted, this takes on the default value of 1 (i.e. begin the search at the start of the within_text string)