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 best Excel tip of 2024
For the second year running, I’m delighted to have participated in John Michaloudis‘ The Best Microsoft Excel Tips & Tricks in 2024. This annual tradition is a roundup of tips and tricks from Microsoft MVPs and experts that will save…
-
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…
End of content
End of content