Oops, pasted the wrong formula in - this one will increment the numeric
digits when the right-most character gets to "Z":

=LEFT(A1,2) & TEXT(MID(A1,3,4)+(RIGHT(A1,1)="Z"),"0000") &
CHAR(MOD(CODE(RIGHT(A1,1))-64,26)+65)

Copy down as far as necessary.

In article ,
JE McGimpsey wrote:

Can't do it with autofill, but you could use a formula, the general form
of which would be:

=LEFT(A1,6)&CHAR(MOD(CODE(RIGHT(A1,1))-64,26)+65)