Article updated on March 17, 2018

SEARCH function

The function returns 11 in cell C5. Text string "blue" is found on character 11 in "My car is blue". See cell range F5:S6.

Excel function syntax

SEARCH(find_text,within_text, [start_num])

Returns the number of the character at which a specific character or text string is found reading left to right (not case-sensitive)

Arguments

find_text - Is the text you want to find. ? and * wildcard characters are allowed.

within_text - is the text in which you want to search for find_text

start_num - is the character number in within_text, counting from the left at which you want to start searching. Optional, if omitted 1 is used.

Comments

If a text string is not found in the cell the SEARCH function returns a #VALUE! error. To avoid that you can use the ISNUMBER function to make the function return TRUE or FALSE

FIND function

The function works the same as the search function except case-sensitive.

Download excel *.xlsx file

Search and Find functions.xlsx