+ Reply to Thread
Results 1 to 3 of 3

a formula to get a cell column letter based on a number

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Question a formula to get a cell column letter based on a number

    Is there an easy way to output a cell column letter if I have the column number?

    For example, in cell B2 I would like to have a formula that looks at cell B3, which has a value of, say, 29 in it. Then B2's formula generates the letter of the 29th column - "AC" in this case. How can I do this with a formula without involving VB?

    I've used
    =SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") to generate a long string of column letters, and then used a look up function to look up the letter based on desired column number, but that's a bit cumbersome.

    Thank you
    Last edited by luv2glyd; 06-03-2011 at 02:53 PM.
    You either quit or become really good at it. There are no other choices.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: a formula to get a cell column letter based on a number

    Hello, Try,

    =SUBSTITUTE(ADDRESS(1,B3,4),1,"")
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: a formula to get a cell column letter based on a number

    Perfect! Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1