convert text to number

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Novice excel 2007 user just can't working for days on this please help. can
you please tell me how to convert single text in one cell to a number in
another cell, example i need the letter W converted to number 6
the letter L converted to number 0, and H to be half the value i assign to
it. any help would be great apprecieated. Thanks Tom--
tom naz
 
If you have only these options then use
=IF(A1="W",6,IF(A1="L",0,IF(A1="H",A2/2,A1)))
Assuming value to test is in A1
and double the value to be assigned for H is in A2

Otherwise use VLOOKUP
Enter in Col C
W
L
H
In Col D
6
0
3 or what you want for H
and so on

Then in B1 use
=VLOOKUP(A1,C:D,2,False)
 
Back
Top