Learn how to use different spreadsheet functions in Excel, OpenOffice Calc, and Google Sheets. All functions have been explained step-by-step for you to easily master them and use them in your spreadsheets.
VBA code to display or convert text to Upper Case using VBA UCase Function without using UPPER Function in each cell. For example, if you have an alphanumeric like “17Agpjps9630d1zi” using this code will display “17AGPJPS9630D1ZI” even if the entries are done in lowercase or proper case.
Convert Text to Upper Case VBA UCase Function Read More »
With this single code, you can use SpellNumber Function for US Dollar, Canadian Dollar, Australian Dollar, European Euros, Great Britain Pound, Japanese Yen, UAE Dirham, Saudi Riyal, South African Rand, Thai Baht, and Sri Lankan Rupee.
SpellNumber – Convert Number To Words In Excel Read More »
Learn to add a Clear Content Button Google Sheet with the help of App Script. This will simplify tedious jobs and save time. Usually, we need to do many tasks repeatedly while creating spreadsheets in Google Sheet. These include clearing cells, deleting ranges, printing ranges, etc. You can automate these tasks with the help of App Script in Google Sheet.
How To Insert Clear Content Button Google Sheet? Read More »
Usually, we need to do many tasks repeatedly while creating spreadsheets in OpenOffice Calc. These include clearing cells, deleting ranges, printing ranges, etc. You can automate these tasks with the help of Macros in OpenOffice Calc. Here, we will learn how to insert a command button to Clear Contents of a specific range in OpenOffice Calc.
How To Insert Clear Content Button OpenOffice Calc? Read More »
Usually, we need to do many tasks repeatedly while creating spreadsheets in Excel. These include clearing cells, deleting ranges, printing ranges, etc. You can automate these tasks with the help of VBA in Excel. Here, we will learn how to insert a command button to Clear Contents of a specific range in Excel.
How To Add Clear Content Button in Excel? Read More »
In this article, we will learn the step-by-step process to pull data from another sheet in Excel and OpenOffice using Macros and Advanced Filter Option. In Google Sheets, it uses the inbuilt FILTER Function. All the techniques consist of an example to understand the complete process.
How To Pull Data From Another Sheet Based On Criteria? Read More »
SpellNumber Sri Lankan Rupee is an Excel Function manually created with VBA code to change the given number in written words in Sri Lankan Rupees. In simple terms, inserting this function allows you to display the numbers in Sri Lankan Rupee.
SpellNumber Sri Lankan Rupee Function In Excel Read More »
NUMBERTEXT Function is an add-in provided by OpenOffice that converts your numbers to words in OpenOffice Calc. In other words, you can convert a numeric value into words using this function. Similar to Excel, OpenOffice Calc doesn’t have any in-built function to convert numbers to words. As OpenOffice is open-source software, it provides NUMBERTEXT as
How To Use NUMBERTEXT Function in OpenOffice Calc? Read More »
In simple terms, the INR Function in Google Sheets will convert Rs.123456789 to Rupees Twelve Crore Thirty-Four Lakh Fifty-Six Thousand Seven Hundred And Eighty-Nine Only. A step-by-step process to create SpellNumber Function for Indian Currency in Google Sheets.
SpellNumber Indian Rupees Function – Google Sheets Read More »
