in text box i will input the alphabet single letter or double letter ,

now i want to get the position number of the alphabet in label 1

for example if i enter (A = 1 , B=2 ,C=3 ,…Z=26 , AA = 27 , AB = 28 , AC = 29 …ZZ = 702 .

i am using these formulas in excel to get the position number of the alphabet series , formula used in excel to get the position number of the alphabet series =SUMPRODUCT((CODE(MID(A2,LEN(A2)-ROW(INDIRECT(“1:”&LEN(A2)))+1,1))-64)*26^(ROW(INDIRECT(“1:”&LEN(A2)))-1))