Monday, March 16, 2015

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    Mar 16, 2016
question by LCHM:!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:


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?