Extracting a number from an inconsistant text string

[binoos123]

Hi all,
Very good evening...
I have an excel stock price template, where I need the current price to calculate the mid point if the chart.
This is the text I get from the webquerry

Underlying stock: SBIN 2699.00 as on Jul 04, 2014 15:30:36 IST

I need a formula to extract the stock price '2699.00' only from this text.
The problems are sometimes its may change to underlying "stock" to "index", SBIN to RELIANCE or TATASTEEL, and the price some times two digit say 16, some times 6 letters say 150.05, or 8 digits say 15160.00

I have searched our forum and many excel forums, but didnt get a solution yet.
So request a solution as a formula, the text in B1 and need the price at A100. Any help would be highly appreciated
Thank you

 

[binoos123]

Thank you Guys. I used the idea which shared by Gary's Student and working fine for my requirement.
I dont know what I missed with Rick's formula and Clabulis formula, but both formula returns as #Value........

Thank you for your valuable time.....
Regards

 

[István Hirsch]

Thank you Guys. I used the idea which shared by Gary's Student and working fine for my requirement.
I dont know what I missed with Rick's formula and Clabulis formula, but both formula returns as #Value........

Thank you for your valuable time.....
Regards

In the above-mentioned formulas, did you replace A1 with B1?

 

[binoos123]

In the above-mentioned formulas, did you replace A1 with B1?

Yes Friend.... but not working. The idea was good, there is a common word after the price a space and "as"

 

[Rick Rothstein]

Yes Friend.... but not working. The idea was good, there is a common word after the price a space and "as"

For my formula, you replaced both A1's with B1's, correct? If so, I'm not sure why it didn't work for you... I tested it before I posted it and it worked fine for me.