CUSTOM FUNCTION

Custom Formula to Reverse a String in Excel

Dear Friends,   This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is an Inbuilt function to reverse a string but in Excel Formula there is no formula as such to reverse a string. Using that built-in function you can create your own custom formula [...]

How to create User Defined Function in Excel

Dear Readers,   User Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. Previously I have created many different User Defined Functions for different purposes but never told you about How to create Custom Functions in Excel. Therefore in this article I am going to tell you stel by step procedure of creating Custom formula in Excel. [...]

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 Cell. It can be used as normal Inbuilt Formulas of Excel. For writing this function i have used VBScript Regular Expression to Replace all the HTML tags with BLANK "". In code you can see [...]