FINDNTH

Returns the nth occurrence of a substring within a string

FINDNTH(string, substring, occurrence)

Arguments

Argument	Description
string	String(s) to search within for instances of substring
substring	Substring(s) to find within string
occurrence	The number dictating which occurrence of substring will be searched for

Output

Outputs a number representing the index of the nth occurrence of substring within string

Example