How to use the CLEAN function in Excel

In this article, we will learn how to use CLEAN Function in Excel. CLEAN function is a text function which removes the non printing characters and...

How to Capitalize First Letter in Excel

Sometimes we need to follow the standards of English writings even in Excel (which I am not good at). One of the basic standards of English writing is...

Extract number between parentheses from text in Excel

In this article, we will learn how to Extract value between parentheses from D5 in Excel. In simple words, while working with D5 data, sometimes ...

Increment a number in a text string in excel

In this article, we will learn How to increase the number in a text string in Excel. For Instance, you have a large list of items and you need to inc...

Get the Sum of text values like numbers in Excel

In this article, we will learn how to Get the Sum of text values like numbers in Excel. In simple words, while working with text values in datase...

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

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

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 Youtube