I'm a UNIX command line guy, so it shouldn't come as a surprise that I love regular expressions. This simple language allows one to slice and dice text strings with abandon, greatly simplifying data extraction and replacement tasks. Although it's been there since 2010, I was thrilled recently to discover that Google Spreadsheets now supports in-cell regular expressions! It's … [Read more...] about Google Spreadsheet Regular Expression Functions Are Insanely Useful