INDEXOF

Returns the index of a letter, or the first found index of a letter if there are duplicates of that letter in a string

Syntax:

INDEXOF(text, value)

text is the string you want to look at.

value is the letter that you are trying to find the index for.

Example:

If text contains Hello and value contains e:

INDEXOF("Hello", "e")

returns 1

If text contains Hello and value contains l:

INDEXOF("Hello", "e")

returns 2

If text contains Hello and value contains b:

INDEXOF("Hello", "b")

returns -1

-1 means the letter was not found in the text.