To get nth occurrence position of character is very challenging task by using formula in excel. I observed that there are various situation in reporting project where nth occurrence position of character is used for certain data calculations. In such a scenario, it is very difficult to complex excel formula which returns nth position of character for targeted input text.

To resolve such a requirement where nth occurrence position of character needed, I have create a function which will easily give us n position of specific character in targeted text.


Here is Excel Function which will return nth occurrence position of character:

Function Find_N(tFind_What As String, tInput_String As String, N As Integer) As Integer
' Author: Dreams24
' Written for VBA Tricks and tips blog
https://www.vbatricksntips.com

Dim i As Integer
Application.Volatile

Find_N = 0


For i = 1 To N

Find_N = InStr(Find_N + 1, tInput_String, tFind_What)
If Find_N = 0 Then Exit For
Next i
End Function