Find function takes the substring from the B2 cell of Column B and it then matches it with the given string in the A2 cell of Column A. This formula finds Marys age in the sample worksheet. Start_num This is an optional argument wherein you specify the character from which your search must begin.
Find_text The textsub-string you want to locate.
The FIND function in Excel does not allow using wildcard characters. The FIND function is case sensitive. Another example First Excel calculates the part in parentheses A2A3. The location is returned as the number of characters from the start of within_text.