FINDNTH
Returns the nth occurrence of a substring within a string
FINDNTH(string
, substring
, occurrence
)
Arguments
Argument | Description |
| String(s) to search within for instances of |
| Substring(s) to find within |
| The number dictating which occurrence of |
Output
Outputs a number representing the index of the nth occurrence
of substring
within string
Example
Last updated