Remove non-alphanumeric characters in Google Sheets

I recently found I needed to remove non-alphanumeric characters in Google Sheets. I had a column of text containing business names which I needed to format as URL friendly equivalents. For example, I needed to turn these: My Business Name Derek’s World of Fish! Jane & Janet’s Pieland Into these: my-business-name dereks-world-of-fish jane-janets-pieland I achieved […]

Lessons I learned from the design of the NES

famicom-nes

This week I was in the rare position to be able to learn about the design of the Nintendo Famicom (that’s the NES to us Westerners) from its designer Masayuki Uemura. He spoke for a couple of hours at The National Videogame Arcade in Nottingham. We heard about design decisions, successes and failures of the project from it’s inception in Japan to becoming a global phenomenon.

How to run more efficient meetings

I used to think that I didn’t enjoy client meetings. I always felt that they were a waste of time and that I could achieve far more by simply communicating with clients over email. I included phone calls in my definition of meetings too by the way. I felt like email was a much more […]