## 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

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

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

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

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

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

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