Change the letter instead of the number
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!
|