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 […]

Hide your WordPress username for extra security

I love WordPress but there are a few defaults which aren’t great from a security point of view. One obvious example is the way that WordPress makes your username visible to the whole world in the slug of your author archive which generally appears at There is often a link to this URL included on […]