How to extract hypertext link from a cell

[Muda]

Hello everyone,

I am trying to extract using Power Querry in Power BI the hypertext link of an excell cell :

So behind the word "Google" I have the hyperlink pointing on http://www.google.com/

I am trying to find a way to get that hyperlink in a new column in Power Querry.

Do you guys have any clue on this ?

Thanks in advance,

Muda

[MFelix · Accepted solution]

Hi @Muda,

As far as I know this is not possible, even in excel you have to use VBA to achieve this, problably you can change you base to have a VBA formula that retrieves thar URL to another cell and then work with that in you Power BI.

Check this link for getting the information to excel and then add it to your data

https://superuser.com/questions/593492/can-i-use-an-excel-formula-to-extract-the-link-location-of-a-...

Regards,

Mfelix