SEARCH function

description:

Get the location of a string inside the text.

 

syntax:

=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.