convert column number to letter(s)

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.
 
C

Chip Pearson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
convert a number to letter 2
Custom Formating Letters to Numbers while Displaying Letters 2
Adding a number to a letter of the alphabet to get a letter 5
number to character and vice-versa 8
Formula to Increment by Letter not Number 6
Simple calculation where values change to letters? 3
Creating sequential numbers plus a letter 4

Top