To auto convert number to text. pls help.

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?

Please Login or Register  to view this content.

You can also use ascii codes - 65 I think it is should give what you are after. Here is a function that will convert a word into a number based on adding the ascii values of each letter.

Please Login or Register  to view this content.

The -64 just converts A to 1 instead of 65 Which is it's ascii Value, google Ascci table to see what value is assigned to which keyboard character.

Hope this helps

Rob

Sorry code blocks didn't work for some reason.

Please Login or Register  to view this content.

By the way, for this function to work, put it into the VB editor, and you can then use it as a formula "=ASCIINUM("cell where word is")

Rob

Thanks Oeldere help.

Thank you for helping Jindon...

Thanks Rob, thst's great VBA

Originally Posted by Sean Thomas

another function that is easier to understand for the average user

use in cell B1 = ChangeText(A1)

Please Login or Register  to view this content.

------------------------------------------
Thank you Sean Thomas , this is more close what i needed. salute..