Formula to identify Segments of text and percentages

Hi,

Having trouble creating the right formula or VBA code to pull out the desired details from coloumn A in the example to look like coloumn B

I need to retrieve the function with the highest percentage as the dominant function in the string of text with the criteria being the highest percentage. I am not sure if there is a formula I can use or alternatively a VBA code. I hope I have articulated my problem well.

Please see the example sheet showing the desired outcome.

thank you