Skip to main content
Version: Streamsheets 3.0

FIND

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

Syntax

=FIND(Text, WithinText, [FromPos])

Arguments

NameTypeDescription
TextStringA string value to look for.
WithinTextStringA string value to look in.
FromPos (optional)NumberA start position which specifies the first character to start the search at.

Default value: 1

Return

TypeDescription
NumberReturns the place where to find the searched character in the string.

Examples

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