Finding number of instances of a character inside a cell

Yesterday I got an email from one of my readers saying that he wanted to count the number of instances of a characters inside a cell.  To give you a better understanding of the question let me explain the question in detail.For instance: The A1 cell of your excel sheet contains a text string like “All work and no play makes jack a dull … [Read more...]

How to Find Cells containing Formulas in Excel

Few days back I had a huge spreadsheet in which I had to find out the cells containing formulas. Initially, I was totally clueless on how this task can be done.  But later after doing some Google searches I got a few ideas on how I can effortlessly identify the formula cells in excel.And today to share my experiences with you guys, In … [Read more...]

Extract Filenames from Filepath in Excel

Getting filenames from a Filepath looks an easy task at first sight. But actually this is a very cumbersome task when you are dealing with large number of file paths. Very recently I also wanted to do this task and during the process of extracting filenames I found few methods that can automate this process.And today I will be sharing few … [Read more...]

How to Make a Drop Down List In Excel

Drop down list is a tool that can help you to force users into selecting a specific value from a predefined set of values. It is always good to have drop down lists for accepting user inputs.  This approach is better because it validates each input from user against a predefined set of values and hence users can only input valid and … [Read more...]

How to Enable Macros in Excel

Macros can be defined as a set of instructions that can be used to perform some specific tasks in Microsoft Office applications. The availability of macros is very helpful for the users as they can create user defined programs and functions specifically designed to perform their tasks.Although macros are so useful, but if misused they can play … [Read more...]

Find Merged Cells in Excel

There are times when you try to sort a column in your spreadsheet and it throws an error saying that, “To do this, all merged cells should be of same size”. As you can clearly see that this issue is due to the presence of merged cells in the column to be sorted.  To resolve this issue you simply need to find the Merged Cells present in the … [Read more...]

How to Hide Formulas in Excel

Using formulas in excel can make your day to day tasks easier. Excel provides formulas for just about anything. But if you are sharing your spreadsheets with other people then it looks quite rude to write formulas as it is.  All the formulas and the calculation stuff should be hidden from the viewers. The best way to do this is to hide … [Read more...]

Privacy Policy | Disclaimer | About