Sequential alphanumeric cell value

[DataMan123]

I need a formula to follow a numbering from a designated cell and increase by a letter.
Like this:
if cell A1 is 161201A then cell A2 is 161201B and cell A3 is 161201C
and if possible to continue to 161201AA, 161201AB, 161201AC...
Anyone?

 

[godsaaint]

And then it would follow 161201AAA, 161201AAB, 161201AAC?

 

[Rick Rothstein]

I need a formula to follow a numbering from a designated cell and increase by a letter.
Like this:
if cell A1 is 161201A then cell A2 is 161201B and cell A3 is 161201C
and if possible to continue to 161201AA, 161201AB, 161201AC...
Anyone?

Will the letter part of the first cell value always be an "A"?

What is the maximum letter part that will ever need to be "counted" up to?

 

[MickG]

Perhaps:-
A1:- 16120A
A2:- =IF(RIGHT(A1,1)="Z",LEFT(A1,LEN(A1)-1)&CHAR(CODE(RIGHT(A1,1))-25)&"A",LEFT(A1,LEN(A1)-1)&CHAR(CODE(RIGHT(A1,1))+1))

 

[István Hirsch]

Enter this in A1 and copy down:

=SUBSTITUTE(161201&ADDRESS(1,ROW(),4)&"ß","1ß","")

 

[DataMan123]

Istvan,
Perfect!
Can you tell me how to adjust your formula if I want to start the nunbering in another cell? IE: in A3

 

[DataMan123]

MrExcel-

The number will vary(the number relates to two digit year, two digit month, and the next number in the queue), but yes, the letter will always begin with 'A'. Preferably an open ended formula would be nice, though rarely has the sequence pasted 'AR'.

 

[István Hirsch]

Istvan,
Perfect!
Can you tell me how to adjust your formula if I want to start the nunbering in another cell? IE: in A3

Try this:

=SUBSTITUTE(161201&ADDRESS(1,ROW(C1),4)&"ß","1ß","")

If A2 then B1, if A3 then C1, if A4 then D1 etc.

 

[István Hirsch]

MrExcel-

The number will vary(the number relates to two digit year, two digit month, and the next number in the queue), but yes, the letter will always begin with 'A'. Preferably an open ended formula would be nice, though rarely has the sequence pasted 'AR'.

If you start in the first row, this method should work down to the 16,384th row, where the last code is 161201XFD.

 

[DataMan123]

István

Worked perfectly!
=SUBSTITUTE(161201&ADDRESS(1,ROW(C1),4)&"ß","1ß","")
It seems the ROW() needs only any cell reference to function as I need; regardless of the value of referenced cell.
Many thank and Merry Christmas!