Extract Price from String

Here's the situation:

Date	Purchase	Reward
04/03/2018	vendor a 10235 ($15.02)	0.15$
03/29/2018	234 vendor b ($109.47)	0.55$
03/24/2018	vendor a 10235 ($16.68)	0.17$

I want to extract the price in the strings of column B to column D. So far the only formula I found extracts all numbers in the string including vendor numbers.
It's also important to extract with the decimal value still in the same place. (I know that this is easily done by dividing whatever I get from the extraction formula by 100)

Should look like this:

Date	Purchase	Reward	Price
04/03/2018	vendor a 10235 ($15.02)	0.15$	$15.02
03/29/2018	234 vendor b ($109.47)	0.55$	$109.47
03/24/2018	vendor a 10235 ($16.68)	0.17$	$16.68

Thanks!

Try...
=SUBSTITUTE(MID(B2,FIND("(",B2)+1,100),")","")*1

And format cell as currency/accounting.

another way (with PowerQuery)

Try this
Enter formula in D1 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B	C	D
1	4/3/2018	vendor a 10235 ($15.02)	0.15$	$15.02
2	3/29/2018	234 vendor b ($109.47)	0.55$	$109.47
3	3/24/2018	vendor a 10235 ($16.68)	0.17$	$16.68