If A=1,B=2,C=3,...,I=9,J=1,...,Z=8

Try in C1:

=MOD(CODE(B1)-65,9)+1

with B1 contains upper letter.