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 MoreSplit & Trim with Google Sheets using ArrayFormula
The issue is white space.
Read MoreConditional Formatting in Google Sheets
I always forget this, even though it’s super simple. So, I figured the best place to put it so that i would remember… is here in my blog. I use this a lot when I’m working on all kinds of spreadsheets, and I use spreadsheets constantly when I’m working on fonts, and with Adobe inDesign for data merges.
Read More