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

How do I extract part of a text in a cell?
 

There are a couple of ways and the correct answer depends on the layout of
your data strings. In the one you supplied the 5 is the 8th character and you
want 5 characters so this works:-

=MID(A1,8,5)


It may be that you r strings aren't that regular and there are ways around
that using 'Find' so post again with more string example is this doesn't work.

Mike


"CHI" wrote:

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

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

If each string value is always laid out as you showed it...

year<spacemonth<spaceprice<spacesymbol

then you can use Split to get at the piece you want. For example...

InfoLine = "07 Jul 55.00 (BZHSK-E)"
Price = Split(InfoLine)(2)

Rick