All Microsoft Excel Versions

How to get Text & Number in Reverse through VBA in Microsoft Excel

In excel, there are times when we want to get the text reversed completely or their order with VBA code. There can be various requirements, like extra...

How to Compare Text in Microsoft Excel

In this article, we will focus on how to compare strings of two cells in excel to find out the unique entries out of both the columns. There are many...

Compare 2 Columns Through VBA in Microsoft Excel

In case you are wondering how to compare 2 columns of data having rows in millions & extract the unique values among both the columns then you sho...

Generate 3 Unique Random numbers in Microsoft Excel

If you want to generate a list of unique random numbers then you can use RANDBETWEEN functions & VBA RND. In this article, we will generate 3 uniq...

How to get the first word in Microsoft Excel

If you come across a situation in which you require only first word in each line of a cell rather than all the character, then you must read this arti...

Function Keys Shortcut In Microsoft Excel

In this article you’ll learn about: Significance of Function keys in MS-Excel Function keys in combination with modifier (Ctrl, Alt, Shift) ...

Remove Extra Commas In Notepad from Microsoft Excel

While importing text file into excel spreadsheet, unfortunately, it has kept the unwanted commas at the end. It becomes really difficult to remove ext...

7 Examples of For Loops in Microsoft Excel VBA

If you are writing a VBA program & you want to execute the same task multiple times then you can do this by using VBA for loops. VBA is a sequent...

How to Extract Last Word in Microsoft Excel

If you are required to extract last word from a string in excel, then you can use combination of various functions. In this article, we will focus on ...

Count Worksheets In Multiple Files

Consider a situation, where you are encountering with number of excel files on a daily basis & you want a quick mechanism to help you finding the ...

Page 1 of 10512345...102030...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube