Extract a part of a string of data

[datadummy]

I am wondering is it possible to write a formula that can extract a specific part of a string of data?
Example string:

ACETAMINOPHEN 300 MG-CODEINE 30 MG TABLET For this one I would want to single out the 30 not necessarily concerned with the MG.

<colgroup><col width="493" style="width: 370pt; mso-width-source: userset; mso-width-alt: 17521;"> <tbody> </tbody>

 

[Nine Zero]

lots of conditions might need to be met for this to work since there are 2 numbers in string

1. Will it ALWAYS be after the "-" hyphen
2. Will there ALWAYS be an "MG" after the number you need
3. Is there ALWAYS another number prior to reaching the desired number

 

[Fluff]

This works on your sample, but may not work for other values.
=MID(SUBSTITUTE(G2," ",REPT(" ",200)),SEARCH(" MG ",SUBSTITUTE(G2," ",REPT(" ",200)))-300,200)*1