MAX formula for alphabetical letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Seems like it must be simple! I have a row of alphabetical letters from A-Z
and I would like to be able to formulate what the highest alphabetical letter
in that row (Z being the highest). The result therefore is the letter that is
the MAX. Help much appreciated
 
Hi Will:

=CODE(LEFT(UPPER(B1),1))-64

Lets say cell B1 contains the word, “apple”, this formula will convert
it to upper case and return the ASCII code for the first left most
character which is A, and subtract 64, making letter A = 1.

Or

=FIND(LEFT(UPPER(B1),1),“ABCDEFGHIJKLMNOPQRSTUVWXYZ”,1)

Same thing as above except instead of returning the letters code it
will find its position in the formulas array,
“ABCDEFGHIJKLMNOPQRSTUVWXYZ”.

Matt
 
Back
Top