How to Convert Number to Words in Excel in Rupees

Excel does not provide any default function that converts a number or amount in words in Indian rupees or any currency. But it doesn't mean that w...

Custom Excel XLOOKUP Function

The XLOOKUP function is exclusive to the insider program of office 365. The LOOKUP function has many functionalities that overcome many of the weaknes...

Extract Unique Values in Excel using one function

In our previous articles, we have learned how to extract unique values from a range using a combination of different excel functions. Although the...

Create VBA Function to Return Array

As the title suggests, we will learn how to create a user-defined function in Excel that returns an array. We have already learned how to create a...

UDF to Extract only Number

UDF to Extract only Number from a Cell Using VBA in Microsoft Excel   In this article, we will learn how to use VBA code to extract number...

How to Create User Defined Function in Microsoft Excel

In this article, we are going to learn how to create user defined functions in Microsoft Excel by using the VBA. User Defined Function:- Microsoft Ex...

UDF - Extracting Email Address from Text

In case you want a process to help you in retrieving the email address from the string then this article is for you. In this article, we will create U...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube