How to find starting position of one text string within another text String (MKS56: FIND FUNCTION)
Dear Friend you are welcome in "Master Key of Success".
FIND: locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
FIND always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.
Syntax
FIND(find_text,within_text,start_num)
Find_text - is the text you want to find.
Within_text- is the text containing the text you want to find.
Start_num 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.
Remarks
FIND is case sensitive and don't allow wildcard (*,~,?) characters. If you don't want to do a case sensitive search or use wildcard characters, you can use SEARCH
If find_text is "" (empty text), FIND matches the first character in the search string (that is, the character numbered start_num or 1).
Find_text cannot contain any wildcard characters.
If find_text does not appear in within_text, FIND returns the #VALUE! error
If start_num is not greater than zero, FIND returns the #VALUE! Error.
If start_num is greater than the length of within_text, FIND returns the #VALUE! Error.
Use start_num to skip a specified number of characters.
