In a previous post I explored how to ignore blank cells when using the QUERY function in Google Sheets, which had its own distinct way of removing blank cells from the data capture. But how do...

A recent project hit a roadblock when I changed some code depending on the N/search module and refactored it to use N/query module. While I had some initial hassles with accepting the Beta nature of...

Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real...

How many ways can you skin a string? In this article we will look at several ways to remove a character from a string using Python.

After moving my blog to Hugo and then back to Wordpress, I knew there would be a few broken links on my website. The question I asked myself was: How can I create a spider that scans through my...