Category Archives: Excel Formula

How to Get a Full File Path in Excel?

Posted on May 19, 2010 by Admin

Ever needed to find out the full path of your current file? What I mean by full path here is the full location of the active file including the directory path and full file name. If you did, then what … Continue reading →

Posted in Excel Formula, Excel VBA Function, Workbook and Worksheet | Tagged , , | 34 Comments

Remove Non-AlphaNumeric Characters from String

Posted on May 18, 2010 by Admin

The function below will allow us to remove a non alphanumeric character from an input string. Be careful though, lengther the string, more time needed to evaluate each string on the sentence. To bad that I don’t have any idea … Continue reading →

Posted in Excel Formula, Excel VBA Function | Tagged , | 36 Comments

How to get an Acronym using Excel VBA?

Posted on June 17, 2009 by Admin

The purpose of the following example of Excel VBA macro is to get the acronym or an abbreviation of each of the first letter of any given words. Function Acronym(Words As Variant) As String Dim aWord() As String, ix As … Continue reading →

Posted in Excel Formula | Tagged , , , , , , | 35 Comments

Find the Last Day of any Month

Posted on June 9, 2009 by Admin

Simple Microsoft Excel formula to find the last day of any given month. ‘ =DATE(YEAR(A1),MONTH(A1)+1,0) ‘

Posted in Excel Formula | Tagged , , | 34 Comments

Auto Expanding VLOOKUP Table Array

Posted on April 2, 2009 by Admin

Ok, this time I want to talk about how to create a vlookup table array that automatically expanding in accordance with the numbers of available data. As we know, the basic form of Excel VLOOKUP to look for A1 value … Continue reading →

Posted in Excel Formula | Tagged , , , , , , , , , , | 43 Comments

How to create Excel function/formula?

Posted on June 14, 2008 by Admin

This is the reason why the power of Excel when combined with VBA is almost limitless. When we can’t found any Excel function that suite our need, we can built it easily using Excel VBA. If Excel macro or SUB … Continue reading →

Posted in Excel Formula | Tagged | 34 Comments