Alphabet function

ontheDB · #1 (**permalink**) 01-15-04, 14:31

Hi,

is there an Alphabet function in VBA ?
e.g.

function(1) = "A"
function(26) = "Z"
or

function2("A") = 1
function2("Z") = 26

thx

C

shades · #2 (**permalink**) 01-15-04, 15:28

Not sure if you want this but:

=CHAR(65) - A
=CHAR(66) - B
.
.
.
.
.
=CHAR(90) - Z

----------------------

=CODE(A) - 65
=CODE(B) - 66
.
.
.
.
.
=CODE(Z) - 90

shades · #3 (**permalink**) 01-15-04, 15:31

If you want the small letters, then:

=CHAR(97) - a
=CHAR(98) - b
.
.
.
=CHAR(122) - z

Internet Services

Web Development

Digital Marketing

Consumer Tech