Skip to content

Remedy667

Remedy667

We ♥ Horror Fonts

  • Fonts
    • Absender
    • Afraid of the Dark
    • Birthday Massacre
    • Boiler Room
    • Burger Witch
    • Demon Glow
    • Drakoala
    • Flying Sausage
    • Franklinstein
    • Hell Builder
    • Indurske
    • Instant Sinner
    • Leach
    • Odictums
    • Poesan Ghost
    • Printing Block 95
    • Radio Fake
    • Screature
    • Scrungy
    • Skate Bait
    • Union Street
    • Vampliers
    • Zine Time
  • FREE FONTS
  • Blog
  • Cart
  • Contact
  1. Home /
  2. Google Sheets /
Google SheetsRandomnessTutorials

Why isn’t ISNUMBER working in sheets?

February 18, 2021Last updated on: February 18, 2021Published by: Remedy667 0

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 More
Google SheetsRandomnessTutorials

Removing HTML from a Cell in Google Sheets

August 26, 2020Last updated on: February 2, 2021Published by: Remedy667 0

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 More
Google SheetsTutorials

Finding and Fixing “Unwanted Dates” with Fractional Data in Sheets

March 19, 2020Last updated on: February 2, 2021Published by: Remedy667 0

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 More
Google SheetsTutorials

Removing Letters (or Numbers) from a Cell in Google Sheets

February 19, 2020Last updated on: February 2, 2021Published by: Remedy667 0

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

Split & Trim with Google Sheets using ArrayFormula

February 12, 2020Last updated on: February 2, 2021Published by: Remedy667 0

The issue is white space.

Read More
Google SheetsTutorials

Conditional Formatting in Google Sheets

February 6, 2020Last updated on: February 2, 2021Published by: Remedy667 0

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
  • Recent Posts

    • Why isn’t ISNUMBER working in sheets?
    • FREE Valentines for 2021
    • Streaming Horror – November 2020
    • Removing HTML from a Cell in Google Sheets
    • Counting in Google Sheets for SEO
  • Login
  • My Account Logout
  • Spaghetti

    It’s what’s for dinner.

You Are Here:

Remedy667 > Fresh Cuts > Tutorials > Google Sheets

Cart

  • Checkout
  • Purchase History
  • My Account

©2020 Remedy667

  • Fonts
  • FREE FONTS
  • Blog
  • Cart
  • Contact