Hello all,

I have a question. I know how to make excel increase a number as you drag it down, but I need to do that in the middle of a string of numbers. It is easiest to explain it....

I am inventorying stuff and the code each unit is identified by follows the format: "A000AA" So an actual code would be G284XR. I cannot figure out how on earth to make it increase the three digit number in the center as I drag down. I would love to be able to type G200XR, then G201XR and drag it so it automatically increases.

Is there ANY way to do this? Because typing in every single one is going to kill me.

Thanks!