| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Letters to Numbers?
I'm hoping someone might be able to suggest an easy way for the following.
I receive a variable as a letter - e.g. A, B, C etc. I need to convert this to a number, so A = 1, B = 2 etc. Currently I use a Select Case, but obviously that can get quite long (the letter can be anything from A-O, so there are 15 separate cases to state). Anyone got any ideas? TiA, DS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert letters to numbers in Excel? | Excel Discussion (Misc queries) | |||
| Convert numbers to letters in excel | Excel Worksheet Functions | |||
| convert letters to numbers | Charts and Charting in Excel | |||
| Convert letters into numbers. i.e. ABCD = 52 | Excel Worksheet Functions | |||
| How to convert numbers to corresponding letters? Ex: 123 to abc | Excel Discussion (Misc queries) | |||
Threaded Mode
