Sometime our data contain unwanted leading and trailing spaces in excel. But dont be panic. Removing it is very simple. Yuo can use formula...

Sometimes we need to put alternate empty rows in an excel. For this just copy below code and run macro.You are done. Sub InsertAlt...

Sometimes we need to put empty rows in excel for every change in id/values in a column. Below macro helps us to put empty rows for every c...