aparvez007 Member Mar 1, 2024 #1 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 A0JFGAA15400B9JIAA1200C8BAA900D7JA10E6F5G4H3I2J1 Attachments Book1.xlsx 10.6 KB · Views: 3

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 A0JFGAA15400B9JIAA1200C8BAA900D7JA10E6F5G4H3I2J1

GraH - Guido Well-Known Member Mar 1, 2024 #2 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))

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 Member Mar 1, 2024 #3 GraH - Guido said: 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 Click to expand... Thanks dear working fine

GraH - Guido said: 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 Click to expand... Thanks dear working fine