Extract percentage out of text string

[hockey408]

Hello, I need to use a series of formulas and/or VBA to extract the % from the following sample. I want a column that says 90.0704309%, 100%, 35.%, etc.

I have a VBA script that can read numbers and spit that out, however, as you can see below, there are a few nuances such as dollar amounts also appearing in these descriptions, etc. Not to mention, since the VBA can spit out all the numbers, how do I add a decimal back in to get back to the original percentage?

LFL TERM 90.0704309% SOLD
MAX-$20MM GCT 50% SOLD
MAX-$7.5MM GCT 50% SOLD
GROWTH TERM 50% SOLD 211020
REAL ESTATE SEC TERM 35% SOLD
100% SOLD LETTER OF CREDIT

[Fluff13]

If you are using a PC, how about

Please Login or Register  to view this content.

[hockey408]

Thank you! That was a lot easier than the series of formulas and VBA I was trying to use

[Fluff13]

Glad to help & thanks for the feedback.