Extracting multiple percentages from a string with custom function

Hi All!

What I've been trying to do is extract only percentages from a string, and parse them out in neighboring columns. Attaching a photo of what I need the result to be. What I'd like to be able to do, is to do it with a custom funtion from VBA but I'm struggling to get the correct format and or parsing them into separate columns....just coming out 10099857550, for example. It may take the custom funtion to get them into one column, separated by the commas, and then doing functions ie...Left, right, mid, to extract them further. It'd be great to do it with one function. I couldn't do it with textsplit either. The strings are too different to just drag the same text split formula.

Whatever the case, I really appreciate the help! It would save me using and updating a lookup table with new strings coming in regularly.

Thanks!
Will

PercentExtractEx.png

UDF
B2:
=GetPerc(A2)
and copy down

Please Login or Register  to view this content.

Thank you Jindon! This worked like an absolute charm! Exactly what I needed!

You are welcome and thanks for the rep.

Please don't forget to mark the thread as SOLVED.