Find and Replace with Regular Expressions in Google Sheets

File under: anecdotes from my love affair with Google Sheets. This post describes a handy trick for data wrangling in Google Sheets. If you’ve ever had to consolidate a bunch of messy data into a few stem patterns, read on. I recently found myself needing to consolidate a bunch of Google Analytics page view data […]