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),“ABCDEFGHIJKLMNOPQRSTUVWXY Z”,1)
Same thing as above except instead of returning the letters code it
will find its position in the formulas array,
“ABCDEFGHIJKLMNOPQRSTUVWXYZ”.
Matt
--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile:
http://www.excelforum.com/member.php...o&userid=15310
View this thread:
http://www.excelforum.com/showthread...hreadid=375428