Anyone know how to convert number/text to text/number?
example
a=1
b=3
c=5

Let's say
1) coloumn A1 value is "35", any formula/macro can auto convert to "bc" at B1?
2) coloumn A1 value is "ab", any formula/macro can auto convert to "13" at B1?