changing text to numerals

[Guest]

Is there a quick and easy way of changing numbers enter as text (i.e. one,
two, three) to numerals. I have a whole column of numbers entered in text
form that I need to convert!

Thanks

 

[Guest]

What is the "range" of the the text i.e. is it simply "one"," two ","three"
or [for example) "one hundred and tweny four"?

 

[Guest]

Use VLOOKUP:

for example, in cols C & D enter:

one 1
two 2
three 3
four 4
five 5
six 6
seven 7
eight 8
nine 9
ten 10

and in B1 enter:
four
then the following formula:
=VLOOKUP(B1,C,2,0) will return the number 4

 

[Guest]

Thank you. That worked

Use VLOOKUP:

for example, in cols C & D enter:

one 1
two 2
three 3
four 4
five 5
six 6
seven 7
eight 8
nine 9
ten 10

and in B1 enter:
four
then the following formula:
=VLOOKUP(B1,C,2,0) will return the number 4