Change the letter instead of the number

[Guest]

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!

 

[Guest]

In the second row enter:

="P18" & CHAR(65-2+ROW()) and copy down

 

[David Biddulph]

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

 

[Gord Dibben]

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

 

[Guest]

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!