Hello,

I want to create a formula where the input is an alphbet representing a
column (e.g. S) but i want that to be interpretted as a number corresponding
to the alphabets rank (20 in this case). Is there a conversion formula that
exists?

thanks,

RK

=CODE(A1)-64

for caps.
--
Gary''s Student - gsnu200764

For any case:

=CODE(UPPER(A1))-64

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gary''s Student" wrote in message
...
=CODE(A1)-64

for caps.
--
Gary''s Student - gsnu200764

One way:

=CEILING(D2*0.8,1)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"rk0909" wrote in message
...
Hello,

I want to create a formula where the input is an alphbet representing a
column (e.g. S) but i want that to be interpretted as a number corresponding
to the alphabets rank (20 in this case). Is there a conversion formula that
exists?

thanks,

RK

Wrong thread ! ! !


--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"RagDyeR" wrote in message
...
One way:

=CEILING(D2*0.8,1)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"rk0909" wrote in message
...
Hello,

I want to create a formula where the input is an alphbet representing a
column (e.g. S) but i want that to be interpretted as a number corresponding
to the alphabets rank (20 in this case). Is there a conversion formula that
exists?

thanks,

RK

works great.

thanks much.

"RagDyeR" wrote:

For any case:

=CODE(UPPER(A1))-64

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gary''s Student" wrote in message
...
=CODE(A1)-64

for caps.
--
Gary''s Student - gsnu200764

BTW Column S is 19, not 20

Function GetColNum(myColumn As String) As Integer
GetColNum = Columns(myColumn & ":" & myColumn).Column
End Function

=getcolnum("s") returns 19


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 08:34:07 -0800, rk0909
wrote:

Hello,

I want to create a formula where the input is an alphbet representing a
column (e.g. S) but i want that to be interpretted as a number corresponding
to the alphabets rank (20 in this case). Is there a conversion formula that
exists?

thanks,

RK