05-28-2010, 03:50 PM
(This post was last modified: 05-28-2010, 04:05 PM by guin.anirban.)
Is you requirement to get only "Ref"?
If your requirement is to get only "Ref" then you can try the following:
If your requirement is to get only "Ref" then you can try the following:
Code:
str = "Ref1234"
intLen = Len(str)
getstr = ""
For itemCnt = 1 To intLen
char = Mid(str, itemCnt, 1)
If (IsNumeric(char)) Then
Else
getstr = getstr + char
End If
Next
MsgBox getstr