How to Use REGEXEXTRACT Function in Google Sheets (8 Examples)

REGEXEXTRACT is part of the suite of REGEX functions that Google Sheets provides. The function is extremely handy when you are trying to dig out […]

How to Use REGEXREPLACE Function in Google Sheets

REGEXREPLACE is a handy function offered by Google Sheets that lets you quickly replace parts of strings in your sheets. It comes as part of […]

What-If Analysis in Google Sheets | Goal Seek in Google Sheets

When doing data analysis, there may be times when we know what we want as the result, but don’t really know what input values will […]

#616 List of URLS to individual QR codes in Google Sheets

So we have a list of 616 web links that we need to make more accessible to users via QR codes. That would take ages […]

How to Get Running Totals in Google Sheets (Easy Formula)

A running total is a useful aggregation tool that helps you see the cumulative sum of a sequence of numbers at any point in the […]

Creating Candlestick Chart in Google Sheets (Step-by-step)

Charts and Graphs are great visualization tools that give you a birds-eye view of your data and help you make inferences. A candlestick chart is […]

How to Use the INDEX function in Google Sheets (Examples)

The INDEX function is perhaps one of the most under-used functions in Google Sheets. However, if you know the right way to use it, you’ll […]

How to Combine Formula and Text in Google Sheets (2 Easy Ways)

Combining text and numbers is common in spreadsheets, for example when you want to add some context There are a number of cases where you […]

Using Wildcards in Google Sheets (4 Examples)

Wildcards are a very versatile set of symbols that help you select a group of similar strings at a time. In this tutorial, I will […]

How to Convert Text to Date in Google Sheets

Working with dates in Google Sheets can sometimes be quite frustrating. This is because there are so many ways in which dates can be represented. […]

How to Convert PDF to Google Sheets (3 Easy Ways)

We often need to work with data received in the form of a PDF file. You might have a scanned copy of important data that […]

How to Convert Formula to Value in Google Sheets

Formulas always help make data processing easier and faster. As helpful as they are, formulas can sometimes come in the way of what we are […]

We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK