Payment Term Percentage from string of text

Hello Excel Gurus!

I am attempting to obtain the cash savings associated to my teams percent discount with regard to payment terms. Provided is a lengthy list of examples to assure formula functionality. I would like to separate the percentage from the string of text (EG: 10% NET 10, NET 30) ONLY extract the 10%.... There are numerous different types of strings, so it isn't as easy as a simple =(LEFT, 3) formula

Hope one of you all could be of assistance, and as always.. MUCH THANKS!!