yogi_Compute Row By Row Corresponding Column Number For Upto Two Letters At End Of String In Column A

                                           Google Spreadsheet   Post  #1924
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 16, 2016
question by LCHM:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Kuotlw1crJM
Return letter from string and determine alphabet count

I am trying to extract the last character of of a string which could be either a number or a letter. If the character IS a letter (A-Z), I want the formula to return what number that letter is in the English alphabet.

For example I have the following data in A1-A3:

DH000169-192N

DH000193-222

DH000223-265D

In cell B1 I would like the formula to return the "N" as 14 (the 14th letter in the alphabet)

Whereas in B2 I would like the formula to display nothing, or "False" (as there is no letter character at the end of the string.

In cell B3 I would like the formula to return the "D" as 4 (the 4th letter in the alphabet)

Any thoughts on this one?

---------------------------------------------------------------------------------------------------------------------------