Dim i As Integer Dim strtem As String Dim strtemp As String strtemp = "G2d000001" For i = 1 To Len(strtemp) If Asc(Mid(strtemp, i, 1)) >= 48 And Asc(Mid(strtemp, i, 1)) <= 57 Then strtem = strtem & Mid(strtemp, i, 1) End If Next intTemp = CLng(strtem) Print intTemp
Dim strtem As String
Dim strtemp As String
strtemp = "G2d000001"
For i = 1 To Len(strtemp)
If Asc(Mid(strtemp, i, 1)) >= 48 And Asc(Mid(strtemp, i, 1)) <= 57 Then
strtem = strtem & Mid(strtemp, i, 1)
End If
Next
intTemp = CLng(strtem)
Print intTemp