convert column number to letter(s)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can I convert a column number into its corresponding aphabetic letter or letters? For example cell A1 contains the number 5, I want a formula in cell B1 that would give me the letter E. If I change A1 to 27, B1 would change to AA. I have used the CHOOSE function but it only goes up to AC (29 items). Thanks.
 
Scott,

Try the following formula

=LEFT(ADDRESS(1,A1,2),1+(A1>26))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



Scott said:
how can I convert a column number into its corresponding aphabetic letter
Click to expand...
or letters? For example cell A1 contains the number 5, I want a formula in
cell B1 that would give me the letter E. If I change A1 to 27, B1 would
change to AA. I have used the CHOOSE function but it only goes up to AC (29
items). Thanks.
 
Back
Top