nth Occurrence of a string within another
Is there any function that can find the xth occurrence of a string within another?
InStr finds the first. How about if I want to find the position of third "K" in this string: "HEJKK98OBK12K7"?
Note:I have written a function that can do it. I'm looking for a function like InStr in VBA library.
Thank you.
Is there any function that can find the xth occurrence of a string within another?
InStr finds the first. How about if I want to find the position of third "K" in this string: "HEJKK98OBK12K7"?
Note:I have written a function that can do it. I'm looking for a function like InStr in VBA library.
Thank you.
Last edited: