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.