Convert Alphanumeric to string
I need to convert an alpha numeric like this(2EA125478) to a string.
I tried Cstr() but it works for numerics only.
If any body could give me an idea for writing a fucntion or a possible solution.
Any suggestions greatly appreciated.
Re: Convert Alphanumeric to string
If this is Hex value which you are trying to convert to long then you can use the below code
myString = "2EA12547"
Execute "x = &h" & myString
But you cannot excced a max long value which means the string you are trying to convert cannot be more than 8 hex chars. And if you are trying to get just the numeric part of the string out then it just running a loop and filtering the values.