Turn numbers written as words into digits (two - 2, three - 3...)

[analyst0503]

Hello,

I would like to find a formula to turn the right column into the left column.

Is there a way to turn the word twenty four into 24?

This would significantly speed up my work so I would appreciate your help!
Thanks in advance.

 

[Joe4]

There is nothing inherent in Excel that will do that. You will have to use VBA and create your own function in order to do that.
However, the good news is that people have already done this, and you can simply use what they did.
Here is some code you can use to do that: Convert numbers into words

 

[deciog]

analyst0503, Good morning.

I got this model on the Internet, check if it helps with your solution

Link https://www.sendspace.com/file/3a6ry9

decio

 

[analyst0503]

Thank you! Will give it a go

 

[bobsan42]

However, the good news is that people have already done this, and you can simply use what they did.
Here is some code you can use to do that: Convert numbers into words

Isn't this the opposite of what the OP is asking?

 

[Rick Rothstein]

analyst0503, Good morning.

I got this model on the Internet, check if it helps with your solution

Link https://www.sendspace.com/file/3a6ry9

decio

My copy of Norton reacted to the link you posted. It registered some kind of web attack immediately after I clicked your link. My suggestion is that you should delete your message and not use that website to share files... you should stick with well-known sites to do this (I use DropBox).

 

[Joe4]

Isn't this the opposite of what the OP is asking?

Aye!

That is what I get for trying to answer questions too early in the morning before the morning caffeine!
?

 

[kweaver]

You could use one of the several UDFs floating around that converts numbers to words and put that in, say, F1, and fill down.
Something like: =NumToWord(row())

Then, do a MATCH on that column for your text such as: =MATCH(A1,$F$1:$F$100,0)

 

[deciog]

Rick Rothstein, Good Morning.

Thanks I didn't know I had this problem, I'll use your suggestion software

decio

 

[johnnyL]

I will try to address the OP's question tomorrow if nobody else does so in the mean time. I have seen a few attempts on the internet that try to do the words to numbers like the OP asked for, NOT NUMBER TO WORDS, and I haven't found any that work satisfactorily.