Monthly Archives: May 2014

Excel VBA – What is SPLIT Function?

Splitting people OR friends may not be a good idea :) but Splitting data or string becomes necessary to organize it and to put it in more readable format. Here in this article, you will learn about splitting the data/string which is joined with a specific delimiter. Delimiter could be any character or special character. This VBA function basically finds [...]

Excel OFFSET Function – Excel Tutorial

Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number of Rows and Columns from a specific Cell or range. Most importantly this is a function which returns Range Address and not the Value. Did you get it what it is used for? No? Don't worry [...]

Excel Trick – Sheet Protection – Protect it and Stay Free

Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your whole sheet except a cell [...]

Excel Trick – SMART Method to make White Background

Dear Readers,   If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image: How do we do this formatting GENERALLY? [...]

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. [...]