Jul 28 2022 12:55 AM
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!
Jul 28 2022 01:31 AM
SolutionBelow formula may work for you. Give a try on it.
=CONCAT(XLOOKUP(MID(A1,SEQUENCE(LEN(A1)),1),F1:F6&"",G1:G6))
Jul 28 2022 01:43 AM
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)
Jul 28 2022 01:31 AM
SolutionBelow formula may work for you. Give a try on it.
=CONCAT(XLOOKUP(MID(A1,SEQUENCE(LEN(A1)),1),F1:F6&"",G1:G6))