| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a tough question - calculating a number out of an alphanumeric code
Hi, I have been trying to figure this one out, but I have not been able to. I have an alphanumeric code - say BC983X8 - in a cell, and I need to calculate an extra digit based on it. Each letter has a value (place in alphabet+9). How can I do this? -- usingexcel ------------------------------------------------------------------------ usingexcel's Profile: http://www.excelforum.com/member.php...o&userid=37043 View this thread: http://www.excelforum.com/showthread...hreadid=567955 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
| Easy VB code question | Excel Discussion (Misc queries) | |||
| syntax question - cell references in VB code | New Users to Excel | |||
| Calculating the number of Fridays in a month | Excel Worksheet Functions | |||
Threaded Mode
