Description

Returns the 1-based position of the pattern

Syntax

FIND(s1, s2[, n3])

·        s1: target string

·        s2: searched pattern

·        n3: starting position; treated as 1 if not provided

Example

FIND(“Mañana”, “a”)        ® 2

FIND(“Mañana”, “a”, 3)          ® 4

FIND(“Mañana”, “Banana”)    ® 0

FIND(“Mañana”, “M”, 2)         ® 0

Note

Logical conditions treat non-zero as TRUE and zero as FALSE; the result of FIND can directly be used for logical conditions.