FIND
Returns the location of first character of intended text within a given text string
Syntax of Excel Find formula:
=FIND(find_text,within_text,[start_num])
In words:
=FIND(this text, within this text string, starting from this character number in the text string)
Start_num argument is optional and gives the user ability to determine the point from where the find function should initiate looking for intended text. This can be used to exclude certain portion of data or text string.
Examples of Excel Find formula
=FIND(“with”,”Reports with Pivot tables”) returns 9 as the “w” of word “with” is at 9th place from the start.