Formula got munged. The second FIND should be FIND(" " ....

=LEFT(RIGHT(A1,LEN(A1)-FIND("$",A1)),FIND("
",RIGHT(A1,LEN(A1)-FIND("$",A1))))

Cheers

--
macropod
[MVP - Microsoft Word]


"macropod" wrote in message
...
Hi Lio,

Try:
=LEFT(RIGHT(A1,LEN(A1)-FIND("$",A1)),FIND("
",RIGHT(A1,LEN(A1)-FIND("$",A1))))

Cheers

--
macropod
[MVP - Microsoft Word]


"Lio" wrote in message
...
Hi!

Alphanumeric string: "Option Exercise at $22.09 per share."

How does one extract 22.09 from the above alphanumeric string?

I tried the array:


=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9), 1)),0),COUNT(1*MID(A1,ROW(
$1:$9),1)))
But this only returns the first whole number.

Thanks.