I have a string
The first 3 letters of my string are always letters
and the remaining between the last letter and the "_" are numbers
I thought of using instr but I dont know how?
I only want to get the numbers in the case above "123"
So i thought of using
Dim TMP As String
TMP = Text1.Text
For a = 65 To 90
TMP = Replace(TMP, Chr(a), "")
but it gets also the "_" which i dont want.
can you help?