Reversing a string in Excel


In my many years of rummaging through the internet for help, I have seen countless posts where troubled help seekers are told that VBA does not have a built in function to reverse a string. Amature know-alls suggest a makeshift solution using a for-loop; and everyone is happy. Contrary to popular belief, Visual Basics doesContinue reading “Reversing a string in Excel”

Concatenate Range and Retain Formatting


In one of my previous posts, I wrote a function to concatenate the values stored in all the cells of a specified range. That function holds good, if you have a text stored in all the cells, and you just want to club them together. It fails if you have cells containing numeric values: dates,Continue reading “Concatenate Range and Retain Formatting”

An upgrade to the Text() function in Excel


Many of us are familiar with the Text() function. It comes in handy when you set up excel to draft reports for you. It converts a numeric value stored in a cell to a string based onĀ  the format specified by the user. The only thing I hate about that function is that you haveContinue reading “An upgrade to the Text() function in Excel”

What are Volatile Functions in Excel


Excel uses a three stage process to recalculate cells. It first draws a dependency tree, and then lists a calculation chain and then recalculates the cells. Check this link if you are interested in learning more about the recalculation process. Excel determines if a cell’s value depends on another, and decides the order in whichContinue reading “What are Volatile Functions in Excel”