Extract text strings from HTML language in Excel worksheet

[tbuenaflor]

I need to extract the below text strings hightlighted in yellow from the attached excel file into the the Output format below. The text strings needed are embeded, surrounded by html language. The pattern is that the text string that ends in a "%" symbol is followed by the text string in brackets [ ]

I've tried a combination of Regex, and Text to rows but keep on getting stuck. 

Input

Output

Dispay Field	Field
Management Fee %	[Management Fee]
Trustee Fee %	[TrusteeFee]
Service Provider Fee %	[ServiceProviderFee]
Other Expenses %	[OtherFee]
Underlying Funds Fees %	[AcquiredFee]
Gross Ratio%	[TotalExpRatio]
Fee Waiver %	[WaiverFee]
Net Expense Ratio %	[NetExpRatio]

[IraWatt]

Hey @tbuenaflor,

This workflow seems to work:

let me know if any issues

[IraWatt · Accepted solution]

Had another go at it @tbuenaflor, I followed the logic of word with % then [word]

Regex used: 

([\w\s]+%|\[[\w]+\])

However this logic does not seem to hold here:

Hope the workflow helps, please ask if any questions.

[PhilipMannering · Accepted solution]

This gets you most of the way,

[tbuenaflor]

@IraWatt  and @PhilipMannering  Thanks for the replies and solutions! Really appreciate it as I was spining my wheels. 

[IraWatt]

No worries @tbuenaflor glad it helped!