Forum Discussion

kaiyos's avatar
kaiyos
Copper Contributor
Jul 28, 2022
Solved

Converting a set of alphanumeric code into another set of code using a specific naming rule

Hi guys, I would like to ask if is there any way (or formula) for me to convert numbers and alphabets with a rule i established. For example, i set a=1b; b=3b; c=4b, and 0=9q;1=3q; 2=3qb Is ther...
excel
  • Harun24HR's avatar
    Harun24HR
    Jul 28, 2022

    kaiyos 

    Below formula may work for you. Give a try on it.

    =CONCAT(XLOOKUP(MID(A1,SEQUENCE(LEN(A1)),1),F1:F6&"",G1:G6))

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Jul 28, 2022

kaiyos 

Below formula may work for you. Give a try on it.

=CONCAT(XLOOKUP(MID(A1,SEQUENCE(LEN(A1)),1),F1:F6&"",G1:G6))

 

Resources