How to use the LOWER function in Excel

The LOWER function in excel is used to change text case to the lower case. In this article, we will explore how you can use LOWER function to do some...

How to use the CODE Function in Excel

In this article, we will learn about how to use the CODE function in Excel. The CODE function returns the ANSI code (American National Standard In...

How to use the LEN Function in Excel

The LEN function in Excel counts characters in a string. I mainly use it when I need to extract text from a string. The Excel LEN function comes in ha...

How to use the CHAR Function in Excel

The Excel CHAR function is used for converting a number code into its character. Each character in excel has the number code. To convert code into its...

How to use EXACT Function in Excel

The EXACT function in excel compares to strings or cells to tell if they are exactly the same. If they are same, you’ll get TRUE, else FALSE. Yes yo...

How to use the MID function in Excel

In this article, we will learn How to use the MID function in Excel. What do LEFT, MID & RIGHT functions do in Excel ? LEFT function ret...

How to Use TEXT Function in Excel

The TEXT function in Excel is used to convert numbers into text. The fun part is you can format that number to show it in desired format. For example ...

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.