Powerutils is a collection of some 78 free add-ins for Microsoft Excel. Here’s some of the features:

1.Text - Convert to Uppercase, ProperCase, LowerCase, Delete trailing / leading Space, delete specified Number of Characters etc.

2.Numbers - Convert Text Numbers to Real Numbers, convert numbers to text, Shift “-” from end to front, Find lowest / highest number in Range.

3.Header Footer - Put any combination of information including File Path, Name, Sheet Name etc in all sheets in file. Delete all Headers / Footers.

4. Sheets - Sort all Sheets in File, Create Index file (Clickable) of all sheets, Put file information in any cell. Delete all page breaks etc.

5. Range - Reverse data in range, replace all #N/A in sheet with anything, Show all cells with errors, Delete all blank rows / columns, delete / color all duplicates in selected Range, Apply formulas to selected range, apply rounding formula, join cells with anything in between etc.

6.Column & Range - Delete Blank Rows / columns, Insert specified number of rows / columns after every user defined number of rows / columns

7. Fill - Fill blank cells with anything, copy values down to blank cells, Quick numbering of Cells in rows / columns.

8.Add - Add text at begining / end of each cell in range. Add leading zeors to all numbers to make them same size.

9. Miscellaneous - Count number of characters in cell, Text whether cell content is number or Text, Color all cells containing Text / Numbers / Formulas.

Powerutils Homepage