FIND
Finds the position of the first text within the second text.
Unlike SEARCH
, FIND
is case-sensitive.
Usage
FIND(find_text, within_text, [start_position])
Parameters
find_text |
(Required) The substring to search for within the text. |
within_text |
(Required) The text string in which to search for the substring. |
start_position |
The character’s position within the text where the search should begin. Defaults is 1, which starts from the beginning. |
Examples
More information
Returns NOTHING
if the searched text is not found.