This video was made in response to a real-life question. It covers how to create Markdown hyperlinks by combining the contents of two columns in Excel. I used Power Query in Excel on the Mac to do this. The process included extracting dates from a text string, converting them to DD-MMMM format, extracting text between two parentheses and combining the resulting columns with specific text characters to generate the Markdown hyperlinks
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/cl8iyla4olmwunf...
The formula that I used in the demos:
="[" & Date.ToText([Date],[Format="dd MMMM"]) & ": " & [#"Full Name/Title"] & "]" & "(" & [Link] & ")"
A Guide to Markdown: www.markdownguide.org/getting...
MoreQuery Addin: theexceltrainer.co.uk/moreque...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #markdown #concatenate
Негізгі бет Excel Tricks: Creating Markdown Links from Multiple Columns Using Power Query on a Mac
Пікірлер