Skip to main content
Version: Streamsheets 2.5

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.
FromPos (optional)A start position which specifies the first character to start the search at. Default is 1.

Return

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

Examples

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