Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Category Archives for Formulas

5-Popular Ways to Concatenate a Range of Cells in Excel

CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells which you want to combine. It’s simple and easy to apply.But here is a bad news. In concatenate, it’s not possible to refer to an entire range.You need to select all the cells of a range one […]

➲ Continue Reading

Count Cells With Text

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 best methods he can use.In Excel, we have different formulas which we can use to count all the cells where we have text values. But […]

➲ Continue Reading

IFERROR with VLOOKUP

While using VLOOKUP, whenever the value for which you are looking for is not there in the data you get #N/A error. In simple words, whenever VLOOKUP is not able to find the value it returns #N/A. For example, you have a list of employees name and you want to lookup for the name “John”. […]

➲ Continue Reading

How to Convert Negative Number into Positive in Excel

Last week, I got an email from one of my subscribers with a question.Hey Puneet, how many methods we have to convert a negative number into a positive?You know, the thing for which he asked is a common kind of task.I am sure, this often happens with you, when you get some numeric values which […]

➲ Continue Reading

Get First and Last Word

Often we face a situation where we need to get first and last word from a cell/text string in Excel.For example, let’s say you want to extract the first name from a cell where you have both first and last names or you want to extract product name from the product description cell.We do need […]

➲ Continue Reading