| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace letter of alfanumeric value by a specific number
Say A=65, B=66.. etc..
I want to convert the alfanumeric value "AB25" into 656625... Cant find the way to replace A for 65 and B for 66 followed by 25 to make a single number... Is this possible??? THANX |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace letter of alfanumeric value by a specific number
See your later post.
-- David Biddulph "El Criollo" wrote in message ... Say A=65, B=66.. etc.. I want to convert the alfanumeric value "AB25" into 656625... Cant find the way to replace A for 65 and B for 66 followed by 25 to make a single number... Is this possible??? THANX |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
| Formula for cells that contain a specific letter | Excel Worksheet Functions | |||
| linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
| Assigning a number value to a letter? | Excel Discussion (Misc queries) | |||
| how do I find an average number of specific words in a column | New Users to Excel | |||
Hybrid Mode
