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

[kaiyos]

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 there any formula that i can use to get 1b3b4b9q3q3qb as output when i typed abc012 in a certain cell?

Thank you!

[#2 · Accepted solution]

@kaiyos 

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

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

[#3]

@kaiyos 

How to convert Excel column numbers into alphabetical characters

This article discusses how to use the Microsoft Visual Basic for Applications (VBA) function in Microsoft Excel to convert column numbers into their corresponding alphabetical character designator for the same column.

Type conversion functions

Each function coerces an expression to a specific data type.

You could still do your conversion with a function and create your own table :)

=If(A1="F",3;"")

A1=F

B1= 67

C1=CODE(A1)-(B1)

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)