Convert alphabets to numeric values

This got the last one

Please Login or Register  to view this content.

Obviously, it needs more work - but, thanks for the rep!

In Progress

Hi KJX,

Thanks for the rep!

This works for your sample and some others - we'll probably find other up to six digit numbers for which it needs to be tweaked:

Please Login or Register  to view this content.

This Function is a small improvement:

Please Login or Register  to view this content.

A few corrections:

Please Login or Register  to view this content.

You're welcome - there will probably be more tweaks

I anticipate more tweaks but:

Please Login or Register  to view this content.

Have fun and let me know of the next necessary tweak!

Hi!

Thank you for you time!



1.
A prior problem got repeated Post #8
i.e.: False result when any string ends with : Twenty; Thirty;........ Ninety.


2. Error: wherever a "Hundred" is followed by a "Seven" or "Twelve"
Eg: One Hundred Seven
Once Thousand Two Hundred Twelve, etc


Other than these two........ i think everything is perfect! Till now

Originally Posted by xladept

I anticipate more tweaks but:

Please Login or Register  to view this content.

Another Tweak

Please Login or Register  to view this content.

Oh - I'm sure there will be more tweaks - but thanks! And thanks for the rep!

Another Tweak/sktneer:

Please Login or Register  to view this content.

Yes it works now perfectly. What is the largest number which can be converted from words to numeric with this code?

@sktneer - I don't know, I just worked on the examples given and developed no theory

If you have time you can extend this code to take care of any number entered no matter how large it is. Then this code will be a unique code to convert number in words to digits. But I think that will really consume lots of time as well to considering all the possible numbers in question.

This code certainly fulfills the OP's requirement and he must be really pleased with you for this nice code.

@ sktneer - Thanks! I'll go at it from time to time as different challenges arise.

Hi! I tried from 1 - 999999, and that has fulfilled my requirement!

U got it sktneer! ...... am really pleased for such a nice code!
Even you have helped me with a great code before!
You guys are really great & helpful too!

Am really thankfull

You're welcome and thanks for the rep!

Thanks kjxavier for the feedback. In this thread all the credit goes to xladept who has provided you a very nice code.

Moreover if that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

Playing with this (nice job) and getting 900 for Nine Hundred one to Nine Hundred nine, and 9 for Nine Hundred ten.

@ChemistB - I tried those numbers and they worked for me (are you hitting F9 to make it calculate?)!


Oh! Nevermind they have to be in proper case at this time.

Error detected!

Sorry,
It was my fault that i did not recognize the error!


1. Wherever it ends with "Twenty;Thirty;.......Ninety " (repeated)
2. Whenever a number is followed by a "Seven"

Thank you

Originally Posted by xladept

Another Tweak/sktneer:

Please Login or Register  to view this content.

This next installment also handles the ChemistB proper case issue

Please Login or Register  to view this content.

Hi!

Error detected!

1. Single digit "Seven " -> #VALUE!
2. Whenever : Twenty; Thirty;...... Ninety is followed by a "Seven" -> negative result

Thanks for sparing you valuable time!

Originally Posted by xladept

This next installment also handles the ChemistB proper case issue

Please Login or Register  to view this content.

Originally Posted by kjxavier

Error detected!

Sorry,
It was my fault that i did not recognize the error!


1. Wherever it ends with "Twenty;Thirty;.......Ninety " (repeated)
2. Whenever a number is followed by a "Seven"

Thank you

kjxavier,

For each of the numbers reported, you have a blank space after the last word. Remove it and you will have the correct result.


Number with million is not correct:

Seven Hundred Thirty Seven Thousand One Hundred Eighty One 7307181
Eight Hundred Twenty Seven Thousand Five Hundred Ninety Eight 8207598

@ Indi_Ra

Thanks for helping me rectifying some errors


Prob is not just with Million ....

Probs:

1. Single digit "Seven " -> #VALUE!
2. Twenty Seven Thousand -> 207000; Thirty Seven Thousand........ Ninety Seven Thousand


Thanks Indira

2. Error result where it ends with : Twenty; Thirty;...... Ninety -> 2;3;.....9
3. Whenever : Twenty; Thirty;...... Ninety is followed by a "Seven" -> negative result

These are both working for me - I fixed the Seven alone issue

Please Login or Register  to view this content.

Well KJ we meet again convert-alphabets-to-numeric-values.xlsm

Please Login or Register  to view this content.

I hope so - thanks for the rep!

Hi! xladept

Many thanks for all you early codes!

Can you make an extension to the prior code!

I tried it till:ONE HUNDRED MILLION...... n it was really good! but with 2 tweaks!

When it encounters a : Twenty Seven Million; Thirty Seven Million; ..... and One Hundred Million


Please go through the attached Excel sheet!

Thank you again for that excellent code!

Appreciate your early reply!

Originally Posted by xladept

Well KJ we meet again Attachment 346332

Please Login or Register  to view this content.

Hello Again KJ,

Try this:

Please Login or Register  to view this content.

Next

Please Login or Register  to view this content.

Hi KJ,

You're welcome and thanks for the rep! 'Til the next time