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 the
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 to insert a
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 INDEX and MATCH in Excel
INDEX MATCH, when combined, can change the approach you use to lookup values in Excel. Yes, you get it right. The combination of these two functions can match the gap of all
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