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…
Copilot is unavoidable and inescapable
I was only trying to give my rabbit a Hollywood smile using the Format Painter tool, but that blimmin’ Copilot button got in the way again! Thankfully, it is possible to switch it off without fully turning off Copilot. Go…
The evolution of the Global Excel Summit lectern
It’s funny how your memory can play tricks on you. I was convinced the lectern at last year’s Global Excel Summit was made of some shade of mahogany wood — more akin to the traditional ones I grew up seeing…
Reflecting on the Global Excel Summit 2025
Wow! What can I say? It’s crazy to think a week has already flown by since the eve of the Global Excel Summit 2025. Reading all the rave reviews flooding in since has been great. Such is the eagerness of…
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…
