Converting words into numeric value

**tdh885** · 05-15-2007, 12:45 PM

Hi,

I've found plenty of resources explaining how to convert numeric values into English words (http://support.microsoft.com/kb/213360 for example) but nothing for the other way around.

Ideally I'd like to convert Bill into 1, Ben into 2, Weed into 3 etc.

Any help would be greatly appreciated

Tom

**Chard** · 05-15-2007, 12:54 PM

Greetings

Do you have a list of words or do you want a number generated for an unlimited selection of words?

Chard

**tdh885** · 05-15-2007, 01:20 PM

A list of ten words:

1
2a
2b
2c
3a
3b
3c
4a
4b
4c

Cheers

**tdh885** · 05-16-2007, 03:03 AM

Apologies for the bump, I thought you may be on to something?

**Chard** · 05-21-2007, 06:09 AM

Hi Tom

Sorry about the delay.

You could have a worksheet with a list of numbers and in the next column a list of corresponding words.

You could then use the VLOOKUP formula to return whichever word matches and inputted number.

Is that the type of thing you're after?

Chard

**oldchippy** · 05-21-2007, 06:52 AM

Originally Posted by tdh885

Apologies for the bump, I thought you may be on to something?

Does this help?

**Dipyaman** · 10-18-2013, 01:02 PM

Hi,

Is there any formula / macro in excel by which number in English word can be converted into numeric digit ? Eg Thirty Five to be converted as 35 . Pls reply .

**arlu1201** · 10-18-2013, 01:38 PM

Dipyaman,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

**deep.nov91** · 12-01-2013, 04:07 AM

Hi

I am trying to to convert english words to numeric value can anyone provide me solution.

For instance:

Fourty five should be converted to 45

Three thousand four hundred and thirty two should be converted as 3432

Please help me with this.

Rds,

**Pepe Le Mokko** · 12-01-2013, 04:43 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.