Bulk change Format from text to Hyperlinks

[grahamkida]

I have extracted data from Power BI and one column consists of hyperlinks. On first opening the .xlsx file initially sees these as Text - only when they are individually clicked does it convert them to hyperlinks. Could VBA be used to bulk change all url entries in the column from plain text format to hyperlink. Thanks

[davsth]

It seems you can do it in power bi

https://docs.microsoft.com/en-us/pow...inks-in-tables

it could be done in excel but seems easier to do at source. Can you attach a sample workbook with a few lines illustrating your problem. there are instructions in the yellow banner

[grahamkida]

Thanks Davsth - The field is formatted correctly as a active url in Power BI, but this formatting isn't included when exported out to Excel. .. Unfortunately I can't provide a sample as it contains sensitive data. As soon as i try to edit to anonymise sample urls to share them with the forum it then it auto-formats them as a URL.

I just need to know how if you can use VB to convert URLs in a flat file data import from text to hyperlinks.

Thanks again

[davsth]

You can use VBA to turn text into hyperlinks.

Something like https://www.mrexcel.com/board/thread...th-vba.799915/

would work if the values you are interested in are in column B

[grahamkida]

That worked - thank you

FYI here's the complete code I used (assumes text to convert to hyperlinks is in column S which contains a header row (s1))

Please Login or Register  to view this content.