1=A, 2=B, 3=C, 26=Z How do I do this?????? 2

[ftpdoo]

Hi,

I'll be returned a number which will be 1 - 26.. How can I replace the number with a letter of the Alphabet??

ie if intNumber = 1 Then
strLetter = A
elseif
.......
end if

There must be a better way than this to do it????

Thnx,
Jonathan

 

[dsi]

strLetter = Chr(intNumber + 64)

 

[jebry]

Hi Jonathan!

Try using the Char function:

strLetter = Char(intNumber + TheDifference)

I just realized that I can't remember the ASCII values for A-Z, but I imagine you can find them pretty easily.

hth Jeff Bridgham
bridgham@purdue.edu

 

[ftpdoo]

Thnx.. )