Return hyperlinks from web pages with Power Query?

If I use Power Query to return hyperlinked content from a web page, the content isn't hyperlinked when it's returned to Excel.

Is there way to either add a column to the Table with the URLs of the hyperlinks in an adjacent column, or else return hyperlinked text?

Thanks.

Charley

Hi Charley,

The gurus here might come up with a smarter or more convenient way to do this; but here is my 2 cents reply.
NOTE: I have not had the time to test out the advice in the links below, but its worth a try to see if it provides you some solution.

See the two replies from hobbitalex at the bottom of this page.
It shows a way to extract the links with a binary import and then to merge it with the web page import to get the links.

See this page which shows how to use a formula in PQ to convert web addresses into friendly named and clickable hyperlinks

If necessary here is some additional info from Chris Webb to show how one can extract web addresses from text using Text.BetweenDelimiters()

Rudi,

Thank you very much! Chris's article was exactly what I needed!

Charley