Description
The FIND function is used to return the location of the specific character/ word(s)/ text, within a text string. Unlike the SEARCH function, the FIND function is case sensitive.
=FIND(find_text,within_text,start_num)
The FIND function’s syntax has the following arguments:
- Within_text Required.
The text/word(s)/ character being looked for. Remember to enter the correct case of the text as the FIND function looks for case-sensitive values.
- Within_text Required
The text string containing the text.
- 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.
