Help with incresing by increments and copying value.

[umbra]

So I have an excel 2003 sheet that I use at work to make labels for folders. It looks like this:

2012P3245
2012P3245
2012P3245
2012P3245
2012P3246
2012P3246
2012P3246
2012P3246
2012P3247
2012P3247
2012P3247
2012P3247

So I would like to just be able to drag a set of formulas to increase this automatically without having to copy and paste.

For example if they were like numbers:

A5 =A4 + 1
A6 =A4 + 1
A7 =A4 + 1
A8 =A4 + 1

or

A5 =A4 + 1
A6 =Value of A5
A7 =Value of A5
A8 =Value of A5

If I drag the cell down it will increase the way I want 2012P3247 increases to 2012P3248

However, I can't drag to the end because there need to be duplicates of the value in between each new value (as shown above). +1 doesn't produce anything, so is there a formula that duplicates the act of dragging? Then I would need that to work for a cell it wasn't touching or a way to copy just the value of a cell.

Thank you for any help, I've been searching forever and couldn't find anything

[martindwilson]

in a1 to a4
2012P20123245
in a5
="2012P"&RIGHT(A1,8)+1
drag a5 down

[martindwilson]

mind you if you had leading 0 after the P like 2012P00000001 youll need
="2012P"&TEXT(RIGHT(A1,8)+1,"00000000")

[umbra]

It worked! You are the best! I knew there was a way, I just couldn't figure it out. The consecutive zeros won't be a problem until next year.

Thank you very much!