that's not what I wanted, all I want is to avoid typing P18A, P18B, P18C and
so on, if I copy this sequence down it gives me P18A, P19B, P20C, and I don't
want the 18 to change, I wanted the letter to change, your formula give me
P18 a, P18AB and so on, which is really helpful, but not for this one...
Have any other idea....tip!

"Gary''s Student" wrote:

In the second row enter:

="P18" & CHAR(65-2+ROW()) and copy down
--
Gary''s Student - gsnu200738


"Raquel" wrote:

I have a question, lets say that in column A, row 1, I have P18 and in the
same column, row 2, I have P18A, in row 3, P18B, can I continue down with out
retyping, when I tried to do this it changes the number to P19 but is does
not change the letter to C, I want it to change the letter to A,B,C but to
leave the original numbering the same, can this be done!