'How to regexextract link texts from a block of html text

I have a block of html text from which I need to extract the link texts. The HTML code is

<li><span class="jkey-title">Job Field</span> <span class="jkey-info"><a href="/jobs-by-field/agriculture">Agriculture / Agro-Allied</a>&nbsp; , <a href="/jobs-by-field/ngo">NGO/Non-Profit</a>&nbsp; , <a href="/jobs-by-field/project-management">Project Management</a>&nbsp;</span> </li>

What I need is the individual link texts separated by a comma and non-breaking space: Like this:

Agriculture/Agro-Allied, &nbsp; NGO/Non-Profit, &nbsp; Project Management

Here's a link to my spreadsheet

https://docs.google.com/spreadsheets/d/13R-TyBMDc64iocSb7LFNM7np7KMo8icDHKnk-E_kvIo/edit?usp=sharing



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source