Documentation/Calc Functions/FIND

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

FIND

Category:

Text

Summary:

Returns the position of a string of text within another string.You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive.

Syntax:

FIND("FindText"; "Text"; Position)

Returns:

Arguments:

FindText refers to the text to be found.

Text is the text where the search takes place.

Position (optional) is the position in the text from which the search starts.

Additional details:

Examples:

=FIND(76;998877665544) returns 6.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: