Custom Functions

What is User Defined Function (UDF) ?

Microsoft Excel allows us to create our own functions, based on our own need. Such functions are called “User Defined Functions” (UDFs) or Custom Function.

These functions behaves exactly like Excel’s inbuilt formulas. These are helpful in simplifying complicated calculations or string related stuffs. Sometimes, you might have felt, “I wish, Excel had a built-in formula for this calculation” !! No worry, you can create your own formula.. and through all the dirty code behind the bar 😉

4 Steps to Create UDFs

Learn How to create your own Excel formula in 4 simple Steps

Hearing about creating my own defined formula is exiting and feels like a rocket science but trust it's not. Learn here in 4 simple steps how to create your own Custom Function.
4 Steps to Create UDFs

UDF to Convert Numbers to Letters

First of all, wouldn't it be great if we have a built in function in Microsoft Excel to Convert Numbers to Letters. It means, simply, [...]

Random BSN Generator – SoFiNummer Generator

Dear Friends, In one of my previous article, I explained you about Netherlands BSN Number validation. This used to be called as SoFi nummer (Short [...]

By | October 12th, 2017|Categories: Excel Tools, User Defined Function|Tags: , |0 Comments

Validate BurgerServiceNummer (BSN) using Excel VBA

Important Note: This post will make more sense to those who stays in Netherlands. But wait.. even if you do not stay in Netherlands, [...]

Create UDF in Excel in 4 Steps – Your Own Excel Formula

U ser Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. So far, I have created many different User Defined Functions for [...]

Check if file is already open using excel VBA

Dear LEM Readers,   While doing programming with VBA many a times it happens to open an existing file. Before opening that file, it is [...]

How to get Excel Range in Array

Many a times while doing coding in excel, we need all the values stored in a Cell Range in an Array format. So that during [...]

By | June 7th, 2012|Categories: Excel Functions, Excel Macro, User Defined Function|Tags: , |9 Comments

User Defined Function in Excel to Convert Currency to Words

Many a times we require to change the Numbers in Words. For Example: 6734862=Sixty Seven Lakhs Thirty Four Thousand Eight Hundred Sixty Two. In Excel, [...]

How to get Word Count and Letter Count in Excel Formula

Dear Readers, Getting a word Count of a String kept in a Cell, is not so difficult but sometimes you just don't get it how [...]

Excel UDF: How to Get All words in Reverse Order from a String

I created this UDF (User defined Function) to help you in arranging all the Words of a String in Reverse Order. It will put the [...]

Excel UDF: To exctract All Numbers, Special Characters and Alphabets from a String

Sometimes you require to Extract All Numbers and Characters from a mixed String. I have written a UDF (User Defined Function) to extract them. UDF [...]

Strip HTML : How to Remove HTML tags from a String in VBA

In this article I am going to write an User Defined Function (UDF) which is used to remove all HTMLs from a String Stored in [...]

How to Extract Email ID from a String in Cell

If you want to extract email ID from a String Stored in any cell, it is possible by writing a Simple UDF (User Defined Function) [...]