OK, I think I figured out part of it. Now I just need a formula that will add 1 to a alphanumeric value in a cell. For example 0025901E851C would be 0025901E851D.
Also need a formula that will take this value:
and add the first two parts to a cell with the last part already typed in.