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!