How to Count Cells with Text in Excel
Last week one of my readers asked me for a simple formula which he can use to count cells with text. Actually, he was trying to figure out which is
Formulas
How to Insert a Check Mark Symbol [Tickmark] in Excel
Last week while traveling I met a person who asked me a smart question. He was quietly working on his laptop and suddenly asked me this:“Hey, do you know how
How to Quickly Generate Random Letters in Excel
Ever faced a situation where you need to generate random letters?Well, sometimes you do need to generate some random alphabets.Right?In Excel…You have functions like RAND and RANBETWEEN to generate random
How to use Wildcards with VLOOKUP in Excel
I’m sure you want to make VLOOKUP more powerful. Well, using wildcards with VLOOKUP can do this for you. It can help you to look up for a value using a partial
How to Concatenate with a Line Break in Excel
In Excel, when we normally combine text from different cells using CONCATENATE. But sometimes while doing this we need to add a line break between the text which we want to
How to Quickly Calculate Ratio in Excel
A ratio is one of the common methods to compare two values with each other. And it can help you to compare variation between those two values. Even in our daily life,