Find position of an letter in an alpha numeric string

[Naded]

I have a column that contain records, each made up of letters and numbers in no particular order. I will like to determine the position of the second letter in a record. I am aware of the Instr() function but I haven't got a clue of what the search criteria should be. Any help will be grateful? Thanks


e.g 12F34567D89101. What is the position of the D

[davegri]

Here's a function that will return the position.

Public Function fcnFindSecond(arg As String) As Long
    Dim i As Integer
    Dim j As Integer
    Dim k As Integer
    j = Len(arg)
    For i = 1 To j
    If Not IsNumeric(Mid(arg, i, 1)) Then
        k = k + 1
            If k = 2 Then
                fcnFindSecond = i
                Exit Function
            End If
    End If
    Next i
End Function

[Naded]

Thank you Sir. it work great