joeloveszoe
Board Regular
- Joined
- Apr 24, 2014
- Messages
- 102
- Office Version
- 365
- Platform
- MacOS
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>
<tbody>
</tbody>
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!!!!!
<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>
2018 - QS - min 1 carton - .94 - volume cost $3.20 - 2018 - QS - min 1 carton - .94 |
2018 - QS - min 1 carton - .94 - volume cost $2.51 - 2018 - QS - min 1 carton - .94 |
2018 - QS - min 1 carton - .94 - volume cost $4.44 - 2018 - QS - min 1 carton - .94 |
2018 - QS - min 1 carton - .94 - volume cost $3.85 - 2018 - QS - min 1 carton - .94 |
<tbody>
</tbody>
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!!!!!