NEW PowerUtilities version 1.8

Back

The Newer version of Powerutils 1.7 which will be distributed in the CD's of Digit magazine and Chip is on its way. Some additions to this version are given below. A trial version can be downloaded which is still in beta stage with one program still without its own gui and with no help. The new programs have not been thoroughly tested, so please check them yourself before applying to live data. Click HERE to download powerutils 1.8 beta.
1. Convert Digit numbers to Text Numbers. Eg. 12,351.45 will be converted to Rs. twelve thousand three undred fifty one and forty five paisa. This program is compete and tested.
2. Break large text files (eg. files downloaded from SAP which are greater than 65536 rows can be split into multiplr smaller files in seconds). This program is compete and tested.
3. Add text at the end of selected range of Data. This program is compete and tested.
4. Find all cells with any type of error in a range then, color it the the way you like it or replace those error cells with anything. Errors include #NUM!, #VALUE, #NAME, #REF and three others. This program is compete and tested.
5. Sum cells in a selected range based on the Cell interior color. This program is compete and tested.
6.Sum cells in a selected range based on the Font color. This program is compete and tested.
7. Count the number cells in a selected range based on the Cell interior color. This program is compete and tested.
8. Count the number cells in a selected range based on the Font color. This program is compete and tested.
9. Rename the current Open File and save it in same place and delete the old name. This program is compete and tested.
10. Delete all sheets in a Workbook which are empty. This program is compete and tested.
11.List all installed fonts in new sheet along with a sample text in that font. This program is compete and tested.
12. Put color number of the background of each cell of  selected column in a new column on right for help in sorting. This program is compete and tested.
13. Put color number of the font of each cell of  selected column in a new column on right for help in sorting. This program is compete and tested.
14. Color all cells with duplicate data in selected range. This program is compete and tested.
15. Color all cells containing user defined data. To be written.
16. Copy Data from excel to word without creating Table like structure (Create pure text). To be written.
17. Send Mass email from within Excel based on email names in sheet and email contents including subject and body in the sheet itself. To be written.
17. Delete print range in worksheet. This program is compete and tested.
18. Delete print range in all the sheets of the workbook. This program is compete and tested.
19. Copy formula without change of reference to a new place. To be written.
20. Count all Unique items in selected column range. To be written.
21. Color cells containing notes in them. To be written.
22. Insert row at every change of data key column. To be written.
23. Change format of Text to sentence case ie. First alphabet after fullstop will be capital. To be written.