Learn how to use different functions in Excel explained with step-by-step instructions to master them and use them in your spreadsheets easily.
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 »
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 »
