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.

Learn MS Excel


Ask Questions

Ask Question