Convert Text To Number Excel

Many times, like when we extract numbers out of string, they be text by property. You can’t do any number operations on them. Then we get the need o...

How to Get Last Value In Column

In this article, we will learn how to retrieve cell address of a lookup value. There will be times when you would want to get address of cell from ...

Excel STANDARDIZE Function

In this article, we will learn about how to use the STANDARDIZE function in Excel. In simple words, normalised value (Z-score) of a value of the da...

How to correct a #NUM! Error

In this article, we will learn about How to correct #NUM! Error in Excel. Excel generates error with a name starting with number sign(#) as soon a...

Shows formula but not result in Excel

In this article, we will learn about how to view formulas in the cell in Excel. Excel performs a function in a cell when using equals to sign (=). ...

How to disable Scroll Lock in Excel

In this article, we will learn about how to disable Scroll Lock in Excel. Arrow keys in excel move your cell up, down, Left & Right. But this f...

How To Unmerge Cells In Excel

Sometimes you get data from your colleague or from a web server that has merged cell for the sake of formatting or any other reason. Now when you try ...

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