change letter into a number

[Guest]

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

 

[Guest]

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

 

[Guest]

Another way:

=Column(indirect(A1 & "1")) and copy down (limit is IV!)

A1=A