FIND function

Description

FIND(needle,haystack[,startpos]) returns the position of a needle within haystack.

The optional argument startpos specifies the character position at which to start the search. The first character in haystack is character number 1. If you omit startpos, it is assumed to be 1.

Example

FIND("a","medcalc") returns 5

FIND("c","medcalc") returns 4

FIND("c","medcalc",5) returns 7

Calculator

Related functions

• List of String functions