Alphbet to number conversion

R

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
 
R

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
 
R

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
 
G

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
 
Top