What would be a good way to increment alpha-numerical characters? I could not think of a way to do this reliably or find a similar example somewhere. Like splitting up the alpha and numeric characters while incrementing the number and joining them together.
A4...stay in A's until it reaches A999999
B4...stay in B's until it reaches B999999
and so on until it gets to Z999999.
The goal is to put in a function, then I could give it a proper value and it would return the next incremented value.