change letter into a number

J

Jshendel

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
 
D

Dave F

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
 
Top