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