Combining two or more column in an excel can simply done using the formula =concatenate(a1,b1) .......................................
Tuesday, July 23, 2013
Sometime our data contain unwanted leading and trailing spaces in excel. But dont be panic. Removing it is very simple. Yuo can use formula...
Monday, July 8, 2013
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...
Friday, June 21, 2013
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...