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!

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!

="P18"&CHAR(63+ROW(A2)) in A2, and copy down
--
David Biddulph

"Raquel" wrote in message
...
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!

One more if you want to go past the letter Z

="P18" & SUBSTITUTE(ADDRESS(1,ROW(),4),"1","")

Entered in A1 and copied to A256

Don't ask me how it works please.


Gord Dibben MS Excel MVP


On Thu, 23 Aug 2007 09:26:02 -0700, 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!

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!