=LEFT(MID(A1,FIND("ET: ",A1)+4,LEN(A1)),FIND(" ",MID(A1,FIND("ET:
",A1)+4,LEN(A1)))-1)

But it returns a string and NOT a number - Did you need it to be numeric?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Ted Metro" wrote in message
...
I have this cell that I'm pulling down from the web --

At 10:12AM ET: 80.00 Up 0.01 (0.01%)

I want to isolate the price, which is 80.00.

Because the # of characters could change, I think the easiest way is to
write a formula to grab the characters to the right of "ET: ".

Now because the price could be single digits to several digits, I think the
formula needs to grab everthing before the decimal and then grab the two
characters after the decimal.

How can I write a formula to grab every character after ET: but before the
decimal, and then grab the decimal and two characters following the decimal?

Ted