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