changing text to numerals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
What is the "range" of the the text i.e. is it simply "one"," two ","three"
or [for example) "one hundred and tweny four"?
 
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:D,2,0) will return the number 4
 
Thank you. That worked



Gary''s Student said:
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:D,2,0) will return the number 4
 
Back
Top