Extract URLs from hyperlinks in Excel
If you copy a set of hyperlinks with friendly text from a website and paste them into Excel, each URL is embedded as part of the cell’s metadata. This poses a challenge if you want to extract them, as there’s…
How the FORMULATEXT function could be improved in Excel
If you’re presenting an Excel formula for auditing, troubleshooting, or educational purposes, the FORMULATEXT function is very handy. It lets you display the formula from a cell (or range) as text, while updating automatically whenever there’s a change. Needless to…
Check out my new Excel Christmas T-shirt!
My new Excel Christmas long-sleeved T-shirt arrived today, and I couldn’t wait to try it on! Here it is… If you’re an Excel longtimer, you will have inevitably faced the #REF! error from time to time. What is so significant…
My advice to Donald Trump about his border choice (Excel edition)
I’m not sure how proficient Mr Trump is at Excel, but I just discovered something bound to pique his interest… 🇺🇸🇲🇽 In the ribbon border dropdown on the Home tab (also found in the right-click formatting menu), selecting ‘Thick Bottom…
The unfortunate truth: Office Scripts is a damp squib
Today, it suddenly dawned on me that Office Scripts has been around for five years. After being announced at the Microsoft Ignite Conference in November 2019, it was reasonable to assume this was going to be the natural replacement for…
I built an alarm clock in Excel
Alarm clocks — who uses one anymore? I’m talking about the dedicated kind — not the virtual one on your smartphone. Last night, I built a quick alarm clock in Excel. This was an offshoot of something else I’ve been…
End of content
End of content