ExcelBanter - change letter into a number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - change letter into a number (https://www.excelbanter.com/excel-discussion-misc-queries/107962-change-letter-into-number.html)

Jshendel

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

Dave F

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

Toppers

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

All times are GMT +1. The time now is 05:32 PM.