INSTR returns the number of coinciding positions of a sub string in a string

Syntax

INSTR([Pos%],Search$, Pattern$)

Arguments

Pos% is optional and a numeric expression that sets the starting position for each search. If omitted, search begins at the first character position.
Search$ is required and a string expression being searched.
Pattern$ is required and a string expression sought in the search string.

Examples

...