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

Thank you!

2 Replies
best response confirmed by kaiyos (Occasional Visitor)
Solution

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

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

``=CONCAT(XLOOKUP(MID(A1,SEQUENCE(LEN(A1)),1),F1:F6&"",G1:G6))`` # Re: Converting a set of alphanumeric code into another set of code using a specific naming rule

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)