find

Previous chapterNext chapter Show allShow all    Hide allHide all

The function find (keystring, string, start) returns the position of a string (keystring) within a text string (string). The position is found in the text string starting at the start character (start) with case-sensitivity.

Syntax: =find(keystring,string,start)

Example Example

Cell A4 = find(A1,A2,A3)

R / C

A

1

cd

2

abcdeABCDEabcde

3

1

4

3