FIND(find_text,within_text,start_num) finds one text value within another (case-sensitive) and return the index : FIND « Text functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =FIND("M",A2)
Input the formula: =FIND
22.9.FIND
22.9.1.FIND(find_text,within_text,start_num) finds one text value within another (case-sensitive) and return the indexFIND(find_text,within_text,start_num) finds one text value within another (case-sensitive) and return the index
22.9.2.=FIND("m",A2)=FIND(
22.9.3.=FIND("M",A2,3)=FIND(