Docs
SEARCH
Finds the position of the first text within the second text.
Unlike FIND, SEARCH is case-insensitive.
Usage
SEARCH(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.