Hello All. I'm hoping someone reading this will be able to help me out. I am familiar with using the Fill function in Excel, but I have a particular challenge that I can't seem to get to work.

I have a list of SSN #'s. I need to increment them by 1 - but in the middle. For example:

001-01-0001
002-01-0001
003-01-0001

Get it? That third number is the one I need to increment by 1 and fill down the column. Does anyone have any ideas on how I can get this done quickly?

Thanks!

PamelaDV