Function AlphaNumber(Alpha As String) As Integer Dim BigAL As String BigAL = UCase$(Alpha) If BigAL Like "[A-Z]" Then AlphaNumber = Asc(BigAL) - 64 End If End Function