S
Steve
Tom is da' man.
(he made an teensy eensy error though)
weensy even...
corrected formulas (formulae, whatever!)
=TEXT(DATE(2003,CODE(LEFT(RIGHT(A2,2),1))-64,1),"mmm")
=IF(LEFT(RIGHT(A2,2),1)<="L","Call","Put")
Steve
(he made an teensy eensy error though)
weensy even...
corrected formulas (formulae, whatever!)
=TEXT(DATE(2003,CODE(LEFT(RIGHT(A2,2),1))-64,1),"mmm")
=IF(LEFT(RIGHT(A2,2),1)<="L","Call","Put")
Steve