how do you number Rows A-Z then AA-ZZ

R

Rebecca Potter

I need to list the rows with A, B, C, at the start and then continuing with
AA, BB, CC - any suggestions please - fill down doesn't work!
 
G

Gary''s Student

In A1 enter:

=LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN(),ROW(),4))-1)

and copy down
 
G

Gary''s Student

This works for Excel 2007. For previous versions of Excel, the equation
fails after IV.

If you are using an older verison of Excel, try this macro:

Sub alphas()
alph = "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z"
v = Split(alph, ",")
icl = 1

For i = 0 To 25
Cells(i + 1, icl).Value = v(i)
Next

irw = 27
For i = 0 To 25
For j = 0 To 25
Cells(irw, icl).Value = v(i) & v(j)
irw = irw + 1
Next
Next

End Sub
 
Top