Possible to get hyperlink data from textfield?

Thanks for your answer. Anonymous

The "problem" is I am downloading large datasets of excel on a daily base and editing excel with command line is a pain in the *** since all of this should run automatically on a server. 

Would be nice if this could become a feature in the future. 

For now I found a workaround with a custom column within powerBI since the domains i want to visit follow the rule of

="staticdomain.com/static/"&[Key]. 

But then again this is not a nice solution since this is only possible due to coherent URLs. But maybe someone with the same problem can also use this meanwhile

I also was trying to mask the hyperlink with text so that I don't see the link itself but rather a text.

To reference the picture above.

Dispaly the text of column1 click on it within a table and it opens the link stored in column2.

Clicking a link is a  ugly solution. People rather want to click keywords. 

regards