Excel How to Create Clickable Hyperlinks in Power Query
Importing a list of URL's into Excel from an external source (CSV, SharePoint, etc) using Power Query is simple but when those URL's are loaded into the worksheet, they aren't clickable. This video shows how, using a simple Power Query command and a simple macro, you can turn them into clickable hyperlinks.
🗒 Notes and Resources
Download a copy of the files used in this video: https://app.box.com/s/iurqpik3238plov...
The formula that I used in the demos:
"=HYPERLINK(""" & [Company_Website_URL] & """)"
Imke Feldmann's Blog Post: https://www.thebiccountant.com/2017/0...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #hyperlink #powerquery
Watch video Excel How to Create Clickable Hyperlinks in Power Query online without registration, duration hours minute second in high quality. This video was added by user Mike Thomas 23 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,80 once and liked it 5 people.