SEARCH
Returns the position at which a string is first found within text.
Usage examples
-
SEARCH("world", "Hello World") -
SEARCH("ello", "Hello yellow", 6)
Syntax
SEARCH ( search_for, text_to_search, [ starting_at ] )
-
search_for- the string to look for within text_to_search. -
text_to_search- the text to search for the first occurrence of search_for. -
starting_at- the character within text_to_search at which to start the search. 1 by default.