SEARCH

Return the index of the search text within the text. The search starts at index.

Syntax

=SEARCH(TextToSearch, Text [, StartAt])

Arguments

NameDescription
TextToSearchText to search for. Note: wildcards like * or ? are supported.
TextText to search inside.
StartAtOptional. Character index to start search at. Default is 1.

Return Value

Position, where the text is found, otherwise #VALUE.

Example

FunctionResult
=SEARCH("me", "Search me now")8
=SEARCH("a*c", "abc")1