Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simplify formula | Excel Worksheet Functions | |||
Can I use AutoFill or a formula to fill a series of letters? | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |