Loop to next letter in Alphabet if condition met.

Hello,

I'm trying to do a project with a positioning system that is in a format that uses both letters and numbers to indicate position. Range of possible values shown in parentheses:

(1-2):(A-F),(1-8)

The very first position would be 1:A,1 and the very last position would be 2:F,8. If the position is 1:A,8 and we're trying to get to the next position, we would have to reset 8 to 1 and then increase A to B.

I can loop through the numbers just fine since excel can do 1+1, but how do I get excel to move onto the next letter of the uppercase alphabet?

Any help would be greatly appreciated!

Awesome, thanks you two!