SEARCH function


Get the location of a string inside the text.



=SEARCH( find_textwithin_text[start_num] )


required arguments:

find_text The string to find.
within_text The text to search within.


optional arguments:

[start_num] A number that represents a year.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.