Converting alpha to number

Hi,

I am wondering if there are any function to change alpha to numbers? What I'm looking for is from "A" to 1, "B" to 2, "J" to 10, "Z" to 26 etc

LVL 1
sataAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ShauliConnect With a Mentor Commented:
Private Sub Command1_Click()
If Asc(UCase(Text1.Text)) < 65 Or Asc(UCase(Text1.Text)) > 90 Then Exit Sub
MsgBox Asc(UCase(Text1.Text)) - 64
End Sub

S
0
All Courses

From novice to tech pro — start learning today.