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 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 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