SUBSTITUTE Function

How to Insert Blank Column Using QUERY in Google Sheets

Often we need to insert one or more blank columns between columns in order to input data that we forgot to insert previously. So it is necessary to ...

How to Split Cells to Get Last Value in Google Sheets (4 Methods)

Getting the last element of cells is often necessary. For instance, we may need to separate different portions of a person's name from a single ...

Google Sheets QUERY Function to Concatenate Two Columns

When trying to organize a group of data on a single page, Google Sheets' ability to combine columns may be quite useful. It can speed up production, ...

How to Use LEN Function in Google Sheets (4 Practical Examples)

The Google Sheets make your work easier by developing some very handy functions. The LEN function is one of them. This function will help you to ...

How to Remove Spaces Between Words in Google Sheets

Excess spaces in data can make it difficult to read and analyze, but Google Sheets can easily remove them. This article will show you how to use ...

How to Use SUBSTITUTE Function in Google Sheets (7 Examples)

We often replace specific text values with other text values. In such scenarios, the SUBSTITUTE function appears very handy. In this article, I’ll ...

Create Hyperlink to VLOOKUP Cell in Multiple Rows in Google Sheets

Suppose you may need to work between different datasets at the same time in Google Sheets. Switching the dataset manually every time is a ...

How to Find and Replace Multiple Values in Google Sheets

Sometimes we input wrong or improper data subconsciously, knowingly or by any kind, and eventually it comes up to correct them all. Obviously, we ...

How to Search and Replace in Google Sheets (2 Easy Ways)

Working with large datasets often requires a change within the sheet and formulas. As a matter of fact, Finding and replacing texts, numbers, and ...

How to Remove Numbers from a String in Google Sheets

Unlike MS Excel, Google Sheets allows the use of regular expressions to find and directly work with alphanumeric values from a cell, of course with ...

How to Remove Comma in Google Sheets (3 Easy Ways)

In this article, we will take a look at a few different ways to remove the comma (,) from data in Google Sheets. Commas can be found in unexpected ...

How to Remove Characters from a String in Google Sheets (6 Easy Examples)

Updating data can involve both adding and removing other data to it. Things become trickier when we have hundreds of updates to perform, which is a ...

How to Substitute Multiple Values in Google Sheets (An Easy Guide)

In this simple tutorial, we will look at how we can substitute multiple values in Google Sheets. Unsurprisingly, our primary method revolves ...

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

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

OfficeWheel
Logo