function to convert A/B/C/... to 1/2/3/4/...

[codecref]

Is there any existing function to convert string like A to 1 and B 2 and so on?

Thanks

 

[chrissie1]

not that I know of but try this

dim letter as string
dim letternumber as integer
letter = "A"
letternumber = Asc(letter.ToUpper) - 64

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[codecref]

good idea, it could have came in my mind .. thanks alot

 

[chiph]

Note that this solution only works for ASCII (character values < 128).

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first