Recently, I tried to build a formula in sheets to tell me whether or not a character in a specific position of a string was a number or not.. Turns out that none of them were? Even though, plain as day… there they are. Numbers.
Read MoreFREE Valentines for 2021
Happy Valentines Day! Instead of buying Valentines, use these monster printables for FREE! They even come in a small batch quantity of 5 per page, perfect for small classrooms, or at-home learning… or, download them as individual jpegs to post on your friends’ social media pages.
Read MoreStreaming Horror – November 2020
Looking for something Spooky? Here are a few titles coming to your streaming box November 2020 for FREE.
Read MoreRemoving HTML from a Cell in Google Sheets
So, I do a lot of editing website data and HTML in Google Sheets. A lot of the time it’s a lot of old stuff that someone else populated, sometimes it’s been extracted from a vendor website, and it’s almost always in need of some sort of repair.
Read MoreCounting in Google Sheets for SEO
So, I’m working on this project where I’m optimizing descriptions for a client using Google Sheets. I need these descriptions to follow a very specific format, and to be sure that they do… I’m using Google Sheets. I’m also using it because I’m going to be populating them through an import with a CSV file. It just makes sense to do it all in one place.
Read More10 FREE Grunge Easter Egg Textures
Slightly late for the holiday, here is a small collection of FREE textures photographed from painted eggs. These textures are perfect for photo or text overlays, use in color or black and white.
Read More36 Days (of Type) Later
This year, kind of at the last minute I decided to join in on the fun of #36DaysofType. I did each letter based on a horror film, and I had a lot of fun… Also, to my surprise, I actually finished it on time.
Read MoreFinding and Fixing “Unwanted Dates” with Fractional Data in Sheets
So, I’ve been tasked with sorting a bunch of data that all has to do with measurements… the only problem is, some of it is fractional, some of it is decimal, and some of it is metric. Which creates a couple of separate issues but right now I’m just going to talk about checking for a specific character in a cell.
Read MoreRemoving Letters (or Numbers) from a Cell in Google Sheets
First off, I should say that this post should actually be called, how to omit any letter in Google Sheets. It’s another one I forget all the time, and searching the web leads to all sorts of things like macros and plug ins.
Read More