A simple bit of Google Apps Script that converts all links within an active Google Sheet into full URL links instead.
Replace Links With URL In Active Google Sheet
Posted on 28/01/2025
Category: Web Stuff
Everything done on the web that is entirely unrelated to WordPress.
Set the APN on GPS Device Using a Hologram SIM Via SMS
A simple guide on how to set the APN on GPS device using a hologram SIM using a SMS message (via the Hologram Dashboard).
Posted on 17/12/2024
Get Last Row in A Column Using Google Apps Script
Another simple bit of code that’s worth writing down: how to get the last row in a specific column using Google Apps Script.
Posted on 08/12/2024
Count Cells That Contain A Word In Google Sheets
A simple bit of code that’s worth writing down for counting all cells in a column that contain a specific word/symbol.
Posted on 08/12/2024
Change Colour Of All Links On Active Google Sheet
A simple Google Apps Script that I came up with to change the colour of every link within the current active sheet all at once.
Posted on 29/07/2024
How To Screenshot Full Browser Pages
Here is a simple and easy to follow guide on how to take a full page screenshot of a webpage on Google Chrome using a Windows computer.
Posted on 08/07/2024
New EU Consent Requirements for Google Analytics
A simple explanation of Google Analytics’ new EU consent rules and how to satisfy them with a simple script.
Posted on 03/04/2024
How to Check if a Cell is a Function Using Conditional Formatting
In this guide, I’ll walk you through the simple steps to set up conditional formatting to identify functions in Google Sheets.
Posted on 02/04/2024
Get Sheet Name in Google Sheets Function
A simple bit of Google Apps Script for a Google Sheet to add a function which returns the name of whatever sheet it’s placed within.
Posted on 02/04/2024
Strip Domains From List of Emails
A simple formula that I use to strip domains (such as “hotmail.co.uk”) from long lists of email addresses in Google Sheets.
Posted on 06/02/2024
