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?
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?
A way to go could be:
Make a table with the letters.
After that use VLookup to find those letters.
b1=Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
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.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.Please Login or Register to view this content.
Hope this helps
Rob
Sorry code blocks didn't work for some reason.
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")Please Login or Register to view this content.
Rob
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.
Last edited by Sean Thomas; 06-23-2014 at 07:15 AM.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Thanks Oeldere help.
Thank you for helping Jindon...
Thanks Rob, thst's great VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks