How to Remove First Character from a Cell in Excel
And after that, I told him about five different methods for this but then he got confused about which method is easy. Even I have created a small UDF to make it super easy for him to remove n number of characters from the start of a string.
How to Add a Vertical Line in a Chart in Excel
How to Add a Vertical Line in a Chart in Excel [Step by Step] Sometimes while presenting data with an Excel chart we need to highlight a specific point to get user’s attention there. And the best way for this is to add a vertical line to a chart. Yes, you heard it right.You can highlight a […]
How to Calculate Time Difference Between Two Times in Excel
As you know, a time value is a numeric value which is formatted as a time but when you deduct one value from another it returns a decimal number and you need format it again as time […]
How to Create a Dynamic Drop Down List in Excel
For this, the best solution is to use a dynamic drop-down list in which you don’t need to update data source again and again.
How to Calculate Age in Excel using Date of Birth
Let’s say you are preparing a data where user’s age is one of the important things to capture. The thing is, if you ask every user to enter his/her age, chances are they can give you an approx number.