Alphbet to number conversion

[rk0909]

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

 

[Gary''s Student]

=CODE(A1)-64

for caps.

 

[RagDyeR]

For any case:

=CODE(UPPER(A1))-64

 

[RagDyeR]

One way:

=CEILING(D2*0.8,1)
--

HTH,

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


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

 

[RagDyeR]

Wrong thread ! ! !


--

Regards,

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

One way:

=CEILING(D2*0.8,1)
--

HTH,

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


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

 

[rk0909]

works great.

thanks much.

 

[Gord Dibben]

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