Documentation/How Tos/Calc: FIND function
From Apache OpenOffice Wiki
< Documentation | How Tos
Revision as of 14:08, 26 February 2009 by OOoWikiBot (talk | contribs) (Robot: Automated text replacement %s)
FIND
Returns the position of a string of text within another string.
Syntax:
FIND(findtext; texttosearch; startposition)
- returns the character position of the first occurrence of findtext within texttosearch.
- startposition (optional) is the position from which the search starts.
- The search is case-sensitive.
- A failed search gives the #VALUE! error.
Example:
FIND("yo"; "Yoyo")
- returns 3.
FIND("cho"; "choochoo"; 2)
- returns 5.