When we have a wordpress or other sites in document root of Magento, we might get some warning like this: Warning: include(file.php):...

Yesterday one of my client ask me they want to show post contents formatted like they added in admin TinyMCE editor with new lines/brea...

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

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