# How to create an alphanumeric series in Excel?

• Using Excel, I want to create a series of letters (e.g. AAA, AAB, AAC,...,ZZY, ZZZ), one per cell. Can this be done using Excel? I've tried working with the series functionality in Excel without any luck. And my knowledge of VB is extremely limited.

thanks,
Rob

• Type your list up in any workbook; AAA through ZZZ.
Then select all 26 cells.
Hit Tools-Options, Data lists. Hit the Import list button.

k?

• Dreamboat, I don't think I understand. I don't want to type the series (AAA, AAB,...ZZY,ZZZ) which would take all day. I want Excel to generate the series.

thanks

• see if this helps : (my ameuter version)

<PRE&gt;

Sub AAA_ZZZ()

o = 0

myA = 65
For q = 1 To 26
myB = 65
For p = 1 To 26
myC = 65
For t = 1 To 26
myCELL = Chr(myA) & Chr(myB) & Chr(myC)
Range("A1").Offset(o, 0).Value = myCELL
myC = myC + 1
o = o + 1

Next t
myB = myB + 1
Next p
myA = myA + 1
Next q

End Sub

</PRE&gt;

pop it in a normal module and it should start at A1 and finish up at A17576

is this what you want ?

• This i have been asked to post from Chris D

Code:

Sub AAA_ZZZ()

o = 0

myA = 65
For q = 1 To 26
myB = 65
For p = 1 To 26
myC = 65
For t = 1 To 26
myCELL = Chr(myA) & Chr(myB) & Chr(myC)
Range("A1").Offset(o, 0).Value = myCELL
myC = myC + 1
o = o + 1

Next t
myB = myB + 1
Next p
myA = myA + 1
Next q

End Sub

• Worked like a charm. Thanks to all.

• Hello. I know it was few years passed but maybe will answer me. I am totally green ( as we say in Poland) and I even do not know how to put this into excel. Maybe someone can show me that already in excel? I can not sleep without getting know how to make this AAA, AAB AAC stuff...

• Welcome to the Forum

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!