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