Excel: Grabbing URL from bunch of HTML tags

[ag1060]

Hi guys,

I'm wondering if you guys could help me out. I'm trying to grab a list of URLs from each row. Each row contains something like this:

<li>The <a href="[URL unfurl="true"]https://blahblah.com">Registered[/URL] Investment Advisor Foreign Account/Anti-Money Laundering Attestation</a> form</li></ul>Once received, this paperwork will be subject to additional review by our Risk department.

I'm trying to grab only the URL from each row. Each url does start with '

https://'

Any suggestion?

Thanks!

 

[SkipVought]

I'd use Data > Text to columns > Delimited on ", Do not import columns 1 & 3

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein