View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chi Chi is offline
external usenet poster
 
Posts: 69
Default How do I extract part of a text in a cell?

I am copying option information from the CBOE website, which contains a
string of characters identifying the option expiry date, strike price, and
ticker symbol (e.g. 07 Jul 55.00 (BZHSK-E). I would like to pull out the 55.00