Check whether Cell Content is a Number. How many times you have used Vlookup or Hlookup formulas only to get a #na. Then you check whether both the key column data are either numeric or text then proceed. Use this util to quickly find out whether the number in the cell is a real number or a text number.
Break 1st Name & Last Name.
This Program will help you split a column containing Names into its First & Surname or First, Middle & Surname. First select the range of data and start the program. You will get a screen like below. Select according to your requirement.
Refresh all Pivot Tables in Current Workbook
With one click you can refresh all the Pivot Tables in the current files. This is more useful where the number o Pivot tables are many.
Count Number of Characters in Cell. This will tell you the number of characters in the correct cell. This util can be used for numbers and text.
Color Cells which are numbers. Select the range then use this util to color all numbers in cells in the color of your choice. It will select only whole numbers in cells which are numeric.
Color Cells which are Text. Select the range then use this util to color all text in cells in the color of your choice. It will select numbers in cells which are really Text.
Color Cells which contain formulas. Select the range then use this util to color all cells containing Formulas, in the color of your choice.
Color Cells which contain Comments. Select the range then use this util to color all cells containing Comments, in the color of your choice.
List all Installed Fonts with Sample. This is a very useful utils. How often you have wished that you could get a visual idea of which font will give the perfect look to the Text of your choice. This util will do just that. Once you start the util, it will ask you to type any text of your choice (a default is given), now click okay and you will find a new file being created with the text chosen and with all available fonts in your system. It will create 150 fonts per sheet. Please try to use this program with minimum number of Applications Running as it hogs a lot of memory for each font being depicted.