How To Use SEARCH Function | Microsoft Excel

SEARCH Function used to find location of character or text string of one string from other text string. SEARCH Function returns the location of the character or text string from the starting point given by user.

Syntax of SEARCH Function

=SEARCH(fnd_text,within_text,[start_num])

Argument of  SEARCH Function

find_text:the text or the character you want to find
within_text: the string in whichy you want to find a specific character
start_num: it is a optional. It is a starting point from where you want to find a specific character

Behaviour of SEARCH Function

A shown in the above
We have use an example of "Pineapple"
The find function will return the specific number on which a character is.
SEARCH p : It will return you 1 because P is at the beginning of the string
SEARCH e  : It will return you 4 because e is at the fourth location of the string
SEARCH l :  It will return you 8 because l is at the eighth location of the string

Use of SEARCH Function

To search the location of the specific character

Return of SEARCH Function

SEARCH Function return the location of the character from the string