Docs
Function 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.
To do the equivalent within a list (instead of within a text), see the CONTAIN function.