FIND, FINDB function
Summary
Finds one text value within another (case-sensitive)
Syntax
FIND(find_text, within_text, [start_num])
The FIND function syntax has the following arguments:
• Find_text Required. The text you want to find.
• Within_text Required. The text containing the text you want to find.
• Start_num Optional. Specifies the character at which to start the search. The first character in within_text is character number 1. If you omit start_num, it is assumed to be 1.
• Find_text Required. The text you want to find.
• Within_text Required. The text containing the text you want to find.
• Start_num Optional. Specifies the character at which to start the search. The first character in within_text is character number 1. If you omit start_num, it is assumed to be 1.
Example
=FIND("M",A2)
=FIND("m",A2)
=FIND("M",A2,3)
=MID(A2,1,FIND(" #",A2,1)-1)
=MID(A3,1,FIND(" #",A3,1)-1)
=MID(A4,1,FIND(" #",A4,1)-1)
=FIND("m",A2)
=FIND("M",A2,3)
=MID(A2,1,FIND(" #",A2,1)-1)
=MID(A3,1,FIND(" #",A3,1)-1)
=MID(A4,1,FIND(" #",A4,1)-1)