 ## Combine QUERY with IMPORTRANGE in Google Sheets

Combine QUERY with IMPORTRANGE in Google Sheets How to use QUERY with IMPORTRANGE Importrange is one of the most useful and powerful functions in Google Sheets. As the name suggests, it imports, or transfers, a range of cells from one spreadsheet to another. Once you... ## How to use the UPPER formula in Google Sheets

How to use the UPPER formula in Google Sheets Numbers are what comes to our mind when we think of spreadsheets applications. That is no surprise because they simplify a lot of calculations for us. Thankfully, their support is beyond just the numbers. We also have... ## How to use the SEARCH formula in Google Sheets

How to use the SEARCH formula in Google Sheets Spreadsheets applications are fantastic utilities at our disposal that not only allows us to tinker with numbers but also with text strings. So along the way, we may find ourselves needing to obtain the position of a... ## How to use the CONCAT formula in Google Sheets

How to use the CONCAT formula in Google Sheets While working with strings on spreadsheets, we may have to do many operations such as trimming, extracting, and converting. What about joining two strings together? Sure, we can do that as well. The CONCAT formula in... ## How to use the SPLIT formula in Google Sheets

How to use the SPLIT formula in Google Sheets Spreadsheets have become the first stop for most of us to handle data. And the nature of the data supported by these applications is not limited to numbers. They seem to provide us with all the requisite tools to tackle... ## How to use the MID formula in Google Sheets

How to use the MID formula in Google Sheets We use spreadsheets not only for number crunching but also for operating on the text-based data as well. There is a built-in support system to easily convert, trim and combine the strings. We know that we have formulas... ## How to use the ROWS formula in Google Sheets

How to use the ROWS formula in Google Sheets Assume that we have a range of cells in a spreadsheet that we are interested in. And we want to know how many rows it has spread across. We could probably do a quick count manually if there are only a few of them. But more... ## How to use the MMULT formula in Google Sheets

How to use the MMULT formula in Google Sheets Spreadsheets have come a long way since they were first available, thereby making our lives a lot easier. Today they provide us with a myriad of tools and formulas, which will help us with most of our mathematical and... ## How to use the LEFT formula in Google Sheets

How to use the LEFT formula in Google Sheets The spreadsheets applications of today are extremely versatile and useful tools. While they are known primarily for handling numbers, they also provide multiple utilities that help us operate on text values. In this post,... ## How to use the LEN formula in Google Sheets

How to use the LEN formula in Google Sheets Using spreadsheets we not only can deal with numbers but also with text. We have a multitude of text formulas at our disposal that can help us manipulate the strings. The LEN formula in Google Sheets is one of them that we... ## How to use the LOWER formula in Google Sheets

How to use the LOWER formula in Google Sheets We know we use the spreadsheets applications generally to working with numbers. But we also have a good help in terms of a number of text-based formulas at our disposal. By making use of these, we can manipulate the... ## How to use the LN formula in Google Sheets

How to use the LN formula in Google Sheets Spreadsheets of today are comprehensive tools that help us with everyday calculations. Be it elementary or advanced, they got a bundle of mathematical functions to offer. The LN formula in Google Sheets helps us to calculate...