Lists in Excel often need to be reshaped depending on the task at hand. Sometimes you’ll have a flat list, where each value appears in its own row without any grouping or hierarchy. If a value occurs multiple times, it…
Five years ago (almost to the day), I published my first-ever blog post. It also happened to be on my birthday, funnily enough. What did I decide to write about? Well, what better place to start than the very thing that…
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…
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…
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…
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…
