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     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?
---------------------------------------------------------------------------------------------------------------------------