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.
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.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks