find within a cell

[joeloveszoe]

hi! in a cell i have text that loos like this

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}</style><style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>
[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]2018 - QS - min 1 carton - .94 - volume cost $3.20 - 2018 - QS - min 1 carton - .94[/TD]
[/TR]
[TR]
[TD="class: td1"]2018 - QS - min 1 carton - .94 - volume cost $2.51 - 2018 - QS - min 1 carton - .94[/TD]
[/TR]
[TR]
[TD="class: td1"]2018 - QS - min 1 carton - .94 - volume cost $4.44 - 2018 - QS - min 1 carton - .94[/TD]
[/TR]
[TR]
[TD="class: td1"]2018 - QS - min 1 carton - .94 - volume cost $3.85 - 2018 - QS - min 1 carton - .94[/TD]
[/TR]
</tbody>[/TABLE]


how can i fins the dollar amount?

looking to strip out
$3.20
$2.51
$4.44
$3.85

thanks in advance for your help!!!!!

 

[VBA Geek]

given the samples provided, it should be like this:

=MID(A1,SEARCH("$",A1),SEARCH(" ",A1,SEARCH("$",A1))-SEARCH("$",A1)+1)

 

[Cranman2127]

Should be able to use a MID formula.
=MID(A1,FIND("$",A1),5)

The 5 at the end of the formula is saying you want the 5 characters once it finds the $.
If you have any values more than five characters long you'll need to adjust the formula.