Excel Trim Not Working – Remove Unwanted Characters Is Your Excel function TRIM not able to remove non-displayable characters? A Trim function will remove only the spaces at start & end of a text. Very less people know that there are other good functions available in Excel to remove special […]
Learn how to add Filter from Excel menu. Also get Excel VBA Autofilter multiple criteria macro code using array list. Learn MS Excel Advanced Filter, VBA code to Read Visible Data & Filter Criteria.
Get free all possible Word combination generator from Letter. Anagram combination generator. This Excel app with code will generate anagrams of all combinations using letters input
GET Free Outlook VBA Code to Save all Email Attachments to a Folder in your Computer. Learn simple macro code to access Emails in a Outlook Mailbox or PST folder
Excel VBA Print Screen Automation – Get FREE VBA Macro to give 1) ALT TAB, 2) Press Print screen Key, 3) save Screenshot to Image file and 4) attach to Excel.
Excel to VCF converter: Get Excel to VCard converter built using VBA. Create Vcard file using contact in Excel. VCF is supported in Android, iPhone & Outlook. VCF file generated can be imported to Android, iPhone & Outlook contacts
Export HTML table to Excel VBA. This code can also be used a Best Data Mining Tool. When Web query did not work, Use the option explained in this article to import Web page Table with just Excel VBA and process the Tags as explained in this quick reference Tutorial.