Forum Discussion
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
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.
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.
I know I don't know anything (Socrates)
