Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
second character from the right
As Steve pointed out, but not in the thread for some reason, there was a
typo in the second formula; =IF(LEFT(RIGHT(A2,1),1)<="L","Call","Put") should be =IF(LEFT(RIGHT(A2,2),1)<="L","Call","Put") -- Regards, Tom Ogilvy Tom Ogilvy wrote in message ... in C2 put in the formula =TEXT(DATE(2003,CODE(LEFT(RIGHT(A2,1),1))-64,1),"mmm") in D2: =IF(LEFT(RIGHT(A2,1),1)<="L","Call","Put") -- Regards, Tom Ogilvy "_______Tim_______" wrote in message ... Hi, If I have Stock Option Symbol "QTHHF" in A2 and the rule is the second character from the right "H" tells me that the Option expires in August and is a Call, how can I write a macro to insert the month in column C and the Call or Putt in column D? Month Call Put Jan A M Feb B N Mar C O Apr D P May E Q Jun F R Jul G S Aug H T Sep I U Oct J V Nov K W Dec L X Second from right. Thank you for your help. Regards, Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
second character from the right
whoops, sorry Tom...don't know what happened there!
On Tue, 12 Aug 2003 19:58:18 -0400, "Tom Ogilvy" wrote: As Steve pointed out, but not in the thread for some reason, there was a typo in the second formula; =IF(LEFT(RIGHT(A2,1),1)<="L","Call","Put") should be =IF(LEFT(RIGHT(A2,2),1)<="L","Call","Put") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
Typing a quote character Vs pasting a quote character= what happens to the resulting CSV? Interesting!! | Excel Programming | |||
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming |