Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert text to number | Excel Discussion (Misc queries) | |||
Convert text number to number formate | Excel Discussion (Misc queries) | |||
how to convert a number to text | New Users to Excel | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions |