In this article, I am going to show you every different way of extracting numbers, text, and punctuation from strings in Google Sheets. To do this, we will mainly use the REGEXREPLACE function, which you can use to replace / extract a variety of characters types from your data. This […]

There are a variety of different ways to combine columns in Google Sheets, and I am going to show you six different formulas that you can use to combine multiple columns into one.  Three of these formulas will combine columns horizontally, and three of them will combine columns vertically. Directly […]

The FILTER function is a very useful and frequently used function, that you will likely find the need for in many situations. The Google Sheets FILTER function allows you to filter your data based on any criteria that you want, automatically with a formula. In this lesson I will show […]