Find last space in Excel cell contents

Respect to this answer: replace spaces as nulls in a string and subtract from the original string length to find out how many spaces there are, then make the last one char(22). Find the char(22) and you have the start point for your mid function. I’m using this...
Intelligent comment is not dead

Intelligent comment is not dead

There were three genuinely interesting and thought-provoking articles in the Indy today. It is a sad fact that I thought this was unusual enough to comment on.We are not drinking more today, the ONS redefined a unit of alcohol in 2005/06 and that’s what makes...

Embargoed

Lovely skit on PR hacks following up unwanted emails. Embargoes

Homeopathic MPs

Hmm. The list of signatories to this Early Day Motion praising homeopathy might be a good reason not to vote for my local MP in the soon-to-be-announced election. His voting record against the government is pretty strong, so maybe he’s a stealth Tory after...

Purple patch for homeopathy

Lovely Mash on homeopathy:The report could see government funding into the not-treatment being stripped back to £1 as according to homeopathic theory it will have the same effect as giving them £100 million.Let’s hope the Simon Singh appeal goes...

Am I too old for Chatroulette?

Apparently people just leave Chatroulette on during parties to see who comes along. I can’t even bring myself to fire it up! For those who don’t know, it is online chat with random people with a big next button so that they (or you) can move on if bored or...

Climate change helps peasants?

Useful to read some challenge to thinking, but always critical to weigh new point evidence against the full set.The contention from Stanford is that some farmers may find increasing crop prices beneficial. And this could well be true, just as the Southern UK should...
Whippet flanges and UK manufacturing

Whippet flanges and UK manufacturing

Helpful myth debunker: UK manufacturing is twice the value it was after World War II. The article also answers the obvious contextual question: how much has GDP increased in the same time frame / what is the trend manufacturing as a proportion of total output? The...
Two ways of looking at ski racing

Two ways of looking at ski racing

Nice graph showing how close the top three were in the men’s downhill, and how Bode was nailing it until the last split.Separately, they started showing a great superposition of Lindsey Vonn and Julia Mancuso (I think) but I haven’t seen it again....