Its very easy to convert excel data into lower and upper cases. For changing into lowercase, use formula                          ...

Combining two or more column in an excel can simply done using the formula =concatenate(a1,b1) .......................................

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...