| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing letters to numbers
I have a group of letters that I would like to change to numbers. namely B to
1 and P to 2. Thanks for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
changing letters to numbers
i am sure it is a little more involved than that,otherwise you could just
change them do p and b appear in a formula or as a result of a formula,or are they choices from a list or.....? -- paul remove nospam for email addy! "Dimitri" wrote: I have a group of letters that I would like to change to numbers. namely B to 1 and P to 2. Thanks for your help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
changing letters to numbers
A little short on info but this may help.
=LOOKUP(A1,{"B","P"},{1,2}) Where A1 has a B or P and the formula cell returns 1 or 2. HTH Regards, Howard "Dimitri" wrote in message ... I have a group of letters that I would like to change to numbers. namely B to 1 and P to 2. Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Changing the Column Headers back to letters from #s | Excel Discussion (Misc queries) | |||
| Change the header columes back to letters not numbers | New Users to Excel | |||
| Converting letters to numbers | Excel Worksheet Functions | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
