Hi
try
=LEFT(TRIM(MID(A1,FIND("ET:",A1)+4,255),FIND("
",TRIM(MID(A1,FIND("ET:",A1)+4,255))-1)

--
Regards
Frank Kabel
Frankfurt, Germany

Ted Metro wrote:
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