| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Letters and Number formulas
I trying to write a formula where if I input any letter into a cell I want
the adjacent cell to display the alphebtic number of that letter. Where A=1 B=2 etc etc Z=26 Example. I put letter d in cell A2 I then want cell B2 to display 4 I put letter z in cell A2 I then want cell B2 to display 26 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, how do I change the column headings from letters to number | Excel Discussion (Misc queries) | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| Counting the number of letters in a cell | Excel Discussion (Misc queries) | |||
| How do you sort words in Excel by the number of letters in a word | New Users to Excel | |||
| Calculating number of letters in a string ... | Excel Worksheet Functions | |||
Threaded Mode
