change letter into a number

G

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Convert word into numbers and back 4
Sorting several columns 1
Need Major Help on the Macro 12
Lookup in a matrix (with x and y headings) based on value x and y 2
Function to convert Excel column into number 2
Search two columns in list for first and last name and return Id 4
Repeat value in column A by number in column B in column C 10
How do I get Excel to automatically group items? 3

Top