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))

     

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jul 28, 2022

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)

Resources