Numbering using letters

R

rayybay

Is there a way to automatic number in Excel using letters instead of numbers?
I tried doing A, B, C in the first three boxes and then using the "+" to make
it continue, but it repeats A, B, C...A, B, C instead. Any ideas? thanks!
 
P

PCLIVE

There are probably several ways to do this. Here is a formula you can use.

=LEFT(ADDRESS(1,ROW(1:1),4),1)

Drag down as needed.
If you will be using more than 26 characters, then:

=IF(LEN(ADDRESS(1,ROW(1:1),4))=3,LEFT(ADDRESS(1,ROW(1:1),4),2),LEFT(ADDRESS(1,ROW(1:1),4),1))

HTH,
Paul
 
R

rayybay

Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...?
Thanks so much!
 
Top