Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Alphabet function

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    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
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    If you want the small letters, then:

    =CHAR(97) - a
    =CHAR(98) - b
    .
    .
    .
    =CHAR(122) - z
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •