SEARCH Function
The SEARCH () is a text function which takes ‘find_text, within_text, start_num’ as argument and returns the location of a character or text string within another text string. The search is not case-sensitive.
Formula:
=SEARCH(find_text, within_text, start_num)
In the above syntax, the argument find_text denotes the text which we need to find out, the argument within_text denotes the text in which we want to search for find_text, and start_num denotes the character number in within_text where we want to start the searching.
Video Tutorial:
Let us see how the SEARCH function returns the location of a substring, with the help of the below video.
