How to COUNT Words in Excel
There is one option which I always wish Excel should have and that’s count number of words from a cell. If you work in MS Word there is an inbuilt option
Formulas
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
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 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