The great ice scam
Here’s my Vanilla Iced Matcha Latte. I purchased it today from Cafe Nero for £4.50. What do you notice? That’s right, it’s full of big blocky ice cubes. There’s about 15 of them filling half the cup that could have…
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…
Insert the current date and time in Windows
In Excel, it’s easy to insert the current date and time into a cell. You only have to press Ctrl + ; for the date and Ctrl + Shift + ; for the time. Use the former, the latter, or…
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…
