Formulas

Calculate if Date is Before Today in Google Sheets

Today we will see how to find and use the condition of if date is before today in Google Sheets. Date calculations are quite common in Google ...

How to Use Today’s Date in Google Sheets (An Easy Guide)

In this simple tutorial, we will look at how we can use today’s date in Google Sheets for different date calculations. We will start with some ...

How to Use the Find Function in Google Sheets (An Easy Guide)

The FIND function comes in handy when you want to search for a keyword with a piece of text or string. And with enough understanding and creativity, ...

How to Remove Special Characters in Google Sheets (3 Easy Ways)

When we think about deleting anything from a spreadsheet, we think about deleting the contents of an entire cell. But sometimes we might need to ...

How to Find and Delete in Google Sheets (An Easy Guide)

Google Sheets is an application powerful enough to recognize most values and patterns in its spreadsheets, making it that much easier to search for ...

Find and Replace with Wildcard in Google Sheets

Wildcards can be a staple when it comes to customizing searches in any Google workplace application. So today, we will answer a few questions and ...

Replace Space with Dash in Google Sheets (2 Ways)

Today we have a look at a couple of different ways by which we can replace space with a dash in Google Sheets. One method talks about direct ...

Find All Cells With Value in Google Sheets (An Easy Guide)

In this simple tutorial, we will show you how you can find all cells with value in Google Sheets. Be it any value or specific value (text or ...

Find Value in a Range in Google Sheets (3 Easy Ways)

Today, we have a look at how we can find a value in a range in Google Sheets. The idea is simple, and we have a few approaches in mind that we can ...

How to Compare Text in Google Sheets (3 Easy Ways)

Today, we have a look at a few ways we can use to compare text in Google Sheets. Let’s get started. 3 Ways to Compare Text in Google Sheets 1. ...

Character Count in Google Sheets (An Easy Guide)

Knowing how to perform a character count in Google Sheets can often come in handy in many situations. And today we will look at some of these ...

How to Count Unique in Google Sheets (3 Easy Ways)

Today, we will look at a few ways we can count unique entries in Google Sheets. While the idea is simple, it also means that there can be multiple ...

How to Concatenate Number and String in Google Sheets

Today we will look at a couple of ways to concatenate number and string in Google Sheets. We will also see some advanced examples based on combining ...

How to Concatenate With Separator in Google Sheets (3 Ways)

Separators, or more technically known as delimiters, are a crucial part of making concatenated values in spreadsheets more presentable. Today, we ...

How to Concatenate Strings in Google Sheets (2 Easy Ways)

Concatenating values is one of the more fundamental tasks performed in a spreadsheet. Today, we will be specifically looking into how to concatenate ...

OfficeWheel
Logo