FIND

Finds the position of the first text within the second text.

Unlike SEARCH, FIND is case-sensitive.

Usage

FIND(find_text, within_text, [start_position])

Parameters

find_text

(Required) The substring to search for within the text.

within_text

(Required) The text string in which to search for the substring.

start_position

The character’s position within the text where the search should begin. Defaults is 1, which starts from the beginning.

Examples

Example With these variables Result

FIND(“word”, “Many words here”)

(None)

6

FIND(“WORD”, “Many words here”)

(None)

NOTHING

FIND(“/”, serial, 10)

serial is "abcde123459/42"

12

More information

Returns NOTHING if the searched text is not found.

See also