All Microsoft Excel Versions

Hide Inactive Workbooks Through VBA

If you are working on multiple workbooks at the same time, and you need a macro to help you in hiding all the inactive workbooks, then this article wi...

VBA - Format Numbers as Social Security Numbers

In the United States, a Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary (working) resi...

Data Validation Allow Particular Numbers & Specific Length

If you are required to add particular numbers with specific length in a range then you can make use of data validation. In this article, we will focus...

VBA to Convert Text from Lower to Uppercase

If you are after a VBA code to allow you to convert all the text in small letters into upper case letter then you should read this tutorial. In this a...

Remove Trailing Space through VBA

In case you want a VBA code to remove all the trailing spaces in only active sheet then this article will definitely help you. Many times we left a sp...

Position of Last Occurrence of Symbol

How to Get Position Of Last Occurrence of Symbol In Microsoft Excel If you want to know the position of a symbol in Excel then you should read this...

Combine First and Last Name Ignoring Middle Name

How to Combine First and Last Name Ignoring Middle Name in Microsoft Excel If you have a list of names in all sort of different formats & you a...

Avoid Nested IF in Microsoft Excel

In case we are using nested IF formula & we all know nested IF takes a lot of time in calculating the result. In this article, we will learn how w...

Replace a Particular Character at Specific Position

How to Replace a Particular Character with Number in Microsoft Excel If you are looking for a formula to replace a particular character on specific...

Convert Small Letters into Uppercase for Some Columns

How to Convert Small Letters into Uppercase Letters for few columns using VBA in Microsoft Excel   In this article we will learn how to con...

Page 2 of 10512345...102030...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube