| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert text "A" to a number using a formula
In cell A1 I have the either Letter a, b or c.
I would like to give them a numerical value of 1, 2 and 3 in the adjacent cell. Can someone post or point me to the formula? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to convert text "A" to a number using a formula
Put this in b1 and drag down
=CODE(UPPER(A1))-64 Mike "yakky" wrote: In cell A1 I have the either Letter a, b or c. I would like to give them a numerical value of 1, 2 and 3 in the adjacent cell. Can someone post or point me to the formula? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to convert text "A" to a number using a formula
Please don't multi-post - you have an answer elsewhere.
Pete On Apr 11, 5:11*pm, yakky wrote: In cell A1 I have the either Letter a, b or c. I would like to give them a numerical value of 1, 2 and 3 in the adjacent cell. Can someone post or point me to the formula? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to convert text "A" to a number using a formula
Pete,
I agree but can't see the other post in this case. Where? Mike "Pete_UK" wrote: Please don't multi-post - you have an answer elsewhere. Pete On Apr 11, 5:11 pm, yakky wrote: In cell A1 I have the either Letter a, b or c. I would like to give them a numerical value of 1, 2 and 3 in the adjacent cell. Can someone post or point me to the formula? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I Convert Number to Text ( example 1 should retun "One" | Excel Discussion (Misc queries) | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
| Why does excel convert my text "6990011011234" to "6.99E+12"? | Excel Discussion (Misc queries) | |||
Hybrid Mode
