Skip to main content

FIND

Finds text within a string value (case-sensitive).

Syntax

=FIND(Text, WithinText[, FromPos])

Arguments

NameDescription
TextA string value to look for.
WithinTextA string value to look in.
FromPosOptional. A start position which specifies the first character to start the search at. Default is 1.

Return Value

Returns the place where to find the searched character in the string.

Example

FunctionResult
=FIND("of", "Tip of the day")5