Converting words to numbers

[vstromer77]

Is there any way to convert words to numbers i.e. 'One' to 1, 'five' to
5 etc etc

I have found how to convert numbers to words but nothing on how to do
the reverse

 

[Don Guillett]

you could make a table
=VLOOKUP(G1,D1:E4,2,0)

 

[Kevin B]

Try perusing this website containing custom functions:

http://www.ozgrid.com/VBA/ValueToWords.htm

 

[Tom Ogilvy]

Somewhere amongst the advertising, there was a VBA procedure that does the
opposite of what the OP asked.