OK, I'm not understanding this but here's what I did:
al0176a
Al0176b
al0176c
al0176d al0176H
al0176e Al0176I
al0176f al0176J
al0176g al0176K
al0176L
al0176M
al0176N
#VALUE!
#VALUE!
#VALUE!
I originally had only al0176a - c maunally typed.
Then I pasted the formula into cell b4 and dragged it down 9 cells, with the
result of al0176H in cell b4 and #value! in the 9 cells under it. Then I
experimented by typing in al0176d in column A and noticed the other column
(cell b5) changed to al0176I. I then typed al0176E in the next cell down of
coulmn A and noticed a change to al0176J in b6. Each time I typed a vlue into
caolumn A, the next cell down changed to the next value sequentially. If I
haven't completely garbled this communication, (heh) is this what should
happen? Main question now: why did b4 receive the value "H" when the last
typed value was "C"?

Is there a place to read up on this?

"JE McGimpsey" wrote:

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)