Mega Code Archive

 
Categories / MSOfficeExcel 2007 Tutorial / Text Functions
 

=SEARCH (y,A1) returns the first place where a y is followed by any two characters

Input the formula: =SEARCH ("y??",A1)