How to use the CONVERT Function in Excel

In this article, we will learn about how to use the CONVERT function in Excel.  The CONVERT function converts a number of one measurement to anoth...

Split Text based on Character/s in Excel

Splitting of texts is one of basic tasks in excel. We often get need of splitting names, ids, address etc. from a concatenated text. To do so we targe...

How to Generate Random text values in Excel

In this article, we will learn to generate random text values in  Excel. For this article we will be needing the use two functions: CHOOSE func...

Partial matches in an array

In this article, we will learn about how to extract all partial matches in an array of values in Excel. For instance, we have a large array of valu...

Split Numbers and Text from String in Excel

Many times I get mixed data from field and server for analysis. This data is usually dirty, having column mixed with number ans text. While doing data...

How to use the REPT function in Excel

The Excel REPT function is a simple function, that prints a given text to given times. In this article, we will explore how REPT function works, how R...

How to Remove Text in Excel Starting From a Position

In this article, we will learn how you can remove a number of characters from a string from a starting position. The excel REPLACE function gives a...

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