Google docs

How to check if value is in range of cells – Solution – Google Sheets

One of the most useful formulas for me was being able to find if a cell contained a value from a list of items, this excellent Excel formula https://exceljet.net/formula/cell-contains-one-of-many-things was exactly what I needed. The formula: =SUMPRODUCT(–ISNUMBER(SEARCH(things,A1)))>0 also works in Google docs, provided that you created a named range. Here is the spreadsheet for you to look …

How to check if value is in range of cells – Solution – Google Sheets Read More »

Google Language & Country code reference sheet

This post is in addition to my previous post on Distilled and simply provides an online Google Docs version of Google CCTLDs and language codes used by Google. If you see any errors, please let me know in the comments and I’ll happily credit you with a link 🙂 The sheet URL is here.  

Count characters in a cell without spaces – Excel & Google docs

By using =Len() you’re going to return the character count including spaces by default. Example: =len(“hey there”) This formula will return 9, this is because there’s a space between “hey” and “there”. Here’s the formula to get character count without spaces: =len(SUBSTITUTE(“hey there”,” “,””)) This will return: 8 How does this work? By nesting the …

Count characters in a cell without spaces – Excel & Google docs Read More »

Scroll to Top