| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change letter into a number
Is there an easy way of changing a letter into a number that increases
linearly? i.e. A=1 B=2 C=3 .. .. .. AA=27 AB=28 etc... Thanks, Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change letter into a number
Well, if your data is sorted alphabetically, then in a column next to the
letters, put the numbers 1 through whatever, and copy and paste those numbers into the column that has letters in it. Dave -- Brevity is the soul of wit. "Jshendel" wrote: Is there an easy way of changing a letter into a number that increases linearly? i.e. A=1 B=2 C=3 . . . AA=27 AB=28 etc... Thanks, Josh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change letter into a number
Another way:
=Column(indirect(A1 & "1")) and copy down (limit is IV!) A1=A "Jshendel" wrote: Is there an easy way of changing a letter into a number that increases linearly? i.e. A=1 B=2 C=3 . . . AA=27 AB=28 etc... Thanks, Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change a currency number display | Excel Discussion (Misc queries) | |||
| Change number when you open the excel template | Excel Discussion (Misc queries) | |||
| adding a number to every change in value | Excel Discussion (Misc queries) | |||
| How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Linear Mode
