Need help to get the formula for my alphabet code to number

[aparvez007]

Hi,
Need help to to get the formula for my alphabet code to number as per below example.

A to J represent the number if I type the code JFGAA I need 15400 as output

A	0​		JFGAA	15400​
B	9​		JIAA	1200​
C	8​		BAA	900​
D	7​		JA	10​
E	6​
F	5​
G	4​
H	3​
I	2​
J	1​

 

[GraH - Guido]

Something like this can work if you have Microsoft 365.
=--TEXTJOIN("";TRUE;XLOOKUP(MID(D2;SEQUENCE(;LEN(D2));1);$A$2:$A$11;$B$2:$B$11))

 

[aparvez007]

Something like this can work if you have Microsoft 365.
=--TEXTJOIN("";TRUE;XLOOKUP(MID(D2;SEQUENCE(;LEN(D2));1);$A$2:$A$11;$B$2:$B$11))

View attachment 86607

Thanks dear working fine