Extract price from text string

[tigerme]

Hi. Please help, I need to extract the price from a text string - they've taken out the currency symbol so it's just the number format #.##

For example

'Spiderman: Web Of Shadows - Amazing Allies Edition (Sony PSP) Game Spanish Box';angelicxrose6_3 Final price: 8.95 (Buy it now).

To return a value of 8.95

or

to return a value of 27.56

it's always before an open bracket (

Thanks in advance!

 

[Sufiyan97]

You're welcome
Glad we could help!

 

[Peter_SSs]

Cheers. And by-the-way: Welcome to the MrExcel Board!