convert text to number
 

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

convert text to number
 

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)


"Tom" wrote:

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

convert text to number
 

Thank you i will give it a try, hope it works. will let you know
--
tom naz


"Sheeloo" wrote:

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)


"Tom" wrote:

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