Latest Posts

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

Insert Page Break in Google Sheets (An Easy Guide)

Printing can be easy in a word document file where the page layout is mostly the same as the page you will be printing. But the scenario is ...

How to Have More than 26 Columns in Google Sheets

Unlike MS Excel, Google Sheets provides its users with only 26 columns (A-Z) to work with off the bat. While this amount is more than enough for the ...

How to Insert a Textbox in Google Sheets (An Easy Guide)

Today, we have for you a simple guide explaining how to insert a textbox in Google Sheets. We dive into the nitty-gritty of the “whys” on top of the ...

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

Compare Two Columns for Duplicates in Google Sheets (3 Easy Ways)

Today we will look at a few ways to compare two columns for duplicates in Google Sheets. While the idea is simple, we can have multiple scenarios ...

Using Conditional Format to Compare Two Columns in Google Sheets

Today we are going to specifically look at how to compare two columns using conditional formatting in Google Sheets. Let’s get started. 2 ...

How to Put Date in Google Sheets (3 Easy Ways)

There are multiple ways of how you can put a date in Google Sheets and our target today is to cover all of these in one single article. We will be ...

OfficeWheel
Logo