Resources

More often than not, to save time or for the sake of laziness, people enter data in all lowercase or all uppercase. Transforming this type of data into the proper format can be a serious headache. Let us show you how to make Excel capitalize first letter...

Is changing the all letters to lowercase manually taking too much time? Let us show you how to convert selection to Excel lowercase using VBA and automate this process. Both Excel and VBA have a function to do this. Both functions use a single argument...

Changing lowercase characters into uppercase is a pretty tedious task if you're doing it manually. In this article, we're going to show you how to make Excel change case to uppercase using VBA Both Excel and VBA have a function to do this. Both use a...

You can remove characters by replacing a character with an empty string (""). Although you can do this by going through all such cells in a selection or specified range using Find & Replace, in this article we're going to show you how to remove...

Printing values instead of the formulas themselves can help protect your IP or prevent users from changing them. In this article, we're going to show you how to have Excel convert formula to value using VBA.   How to have Excel convert formula to...

Users entering data into the wrong cells or changing existing formulas can make data collection a tedious process. However, you can prevent users from going outside the intended boundaries by disabling certain sections of your workbook. In this article,...

The common ways of locking or hiding tabs in a workbook can be easy to reverse for many users. Using VBA code to do this is considered a better way to do this, if you are familiar with macros. In this article, we're going to show you how to 'un-protect' protected...