Add one

[GillianX]

Hi,

This is probably really really easy (I hope)...

I have a column which starts like this:

P1001
P1002
P1003
P1004

But then gets messed up with a load of other different formats of numbers.

I need a formula so that the next cells automatically shows P1005, P1006
etc. Is this possible?

Thanks in advance.

 

[Stefi]

="P"&1000+ROW()
in row1 returns P1001
in row2 returns P1002
etc.
Regards,
Stefi


--
Regards!
Stefi



„GillianX†ezt írta:

 

[Mike H]

Hi,

I may be missing something here but why not just select the cell with P1004
in and drag down?

Mike

 

[GillianX]

Oh my goodness, I can't believe it was that simple - worked perfectly, thanks
so much!!!!

 

[Mike H]

Glad I could help.

Oh my goodness, I can't believe it was that simple - worked perfectly, thanks
so much!!!!