Private Sub Form_Load()
MsgBox RightVal("AAAA333")
MsgBox RightVal("ABC213")
End Sub
Function RightVal(ByVal s As String) As Long
Dim i As Long
RightVal = 0
For i = Len(s) To 1 Step -1
If Not IsNumeric(Mid(s, i, 1)) Then RightVal = Val(Mid(s, i + 1)): Exit For
Next
End Function
Function getit(ByVal x As String) As String
getit = x
Do While Not IsNumeric(Left(getit, 1))
getit = Replace(getit, Left(getit, 1), "")
Loop
getit = Val(getit)
End Function