Alphanumeric Sequence Autofill Options?

[JenniferNorman]

Hi, I'm attempting to autofill an alphanumeric sequence in which the first half of the sequence repeats, only causing the second half to advance in sequence once a certain number is reached.

The code is a two digit number followed by a two digit alphabetic code. The number portion of the code increases to 99, at which time the numbers reset to 01 and the first letter in the alphabetic portion advances by one letter (the second letter only advances once the first letter has cycled from A-Z). In other words, the first code would be 01AA, the second code would be 02AA, etc., until 99AA was reached, at which point the code would be come 01BA, then 02BA, etc.

Is there a way to phrase a command inside Excel that would allow me to quickly generate this sequence instead of manually inputting each code by hand?

I appreciate your time and help! Thanks

 

[RonB1111]

Try:
In cell A2, enter 01AA
In cell A3, enter this formula and then copy it down as far as row 66,925 (maximum combinations are 66,924):

=IF(A2>="99ZZ","---Out of Combinations---",(IF(LEFT(A2,2)="99","01",TEXT(LEFT(A2,2)+1,"00"))&IF(AND(LEFT(A2,2)="99",MID(A2,3,1)="Z"),"A",IF(LEFT(A2,2)="99",CHAR(CODE(MID(A2,3,1))+1),MID(A2,3,1)))&IF(LEFT(A2,3)="99Z",CHAR(CODE(RIGHT(A2,1))+1),RIGHT(A2,1))))