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…
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…
Excel is 39 years old — let’s look back at its many logos
Prediction: Excel will get a new logo next year. On Monday (30 September), Excel celebrated its 39th birthday. This means it’s just one year off the big four-zero. If that milestone is not significant enough, it’s worth remembering that Microsoft…
I’ve never seen the BBC use this chart before — until now
Whilst reading an article about England’s 2–0 win against the Irish yesterday, I came across a couple of charts I’ve not seen the BBC use before. Gauge charts — aka dial charts, speedometer charts, or meter charts. They were used…
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