Finds the first instance of a string within another string. To do a more complex search, such as looking for a string that matches a pattern, use theFind Pattern function instead.
look in is the text you want to search inside.
look for is the text you want to search for.
- position is the position of the first match, where 0 is the first position. Returns -1 if it is not found.
If look in is “This is a test”:
If look for is “T” then position is 0 (first position, where counting starts with 0).
If look for is “test” then position is 10 (11th position).
If look for is “hello” then position is -1 (no instance found).