Solves the most common annoyances in Excel
ASAP Utilities 3.03 is now available for download.
Date: July 3, 2002| New features: | |
| Text - Date Converter | This will convert a text-string-date to another formatted date. I.e. 010101 becomes 1 january 2001, or 2001-12-02 becomes 12 feb 2001. When it comes to importing data from i.e. financial systems, this feature is extremely usefull. Whether the original date is like "mmddyy" or "ddmmyy" this utility will recognize and convert it! The conversion is very flexible.  |
| Undo | I've built an undo option in a few functions. In time most functions will get an undo. |
| Select | Conditional select, added options to select cells that are NOT bold, underlined or italic. |
| Range | Randomize list, by row. Easily randomize the order your list is shown.  |
| Sheets | Add sheet (inputbox will appear for the name) If you enter a name that exceeds 31 characters ASAP will automaticly reduce it to 31 characters. |
| Custom formulas | ASAPCountShades() ? Counts the number of cells that are colored within the given range. ASAPSumByFontColor ? Sums the cells with a given color in a given range. The color is Excels colorindex (1-56). ASAPFontColorIndex ? Returns the fonts colorindex number (1-56).  ASAPFullFilename() ? Returns the full path and filename of the active workbook ASAPFileName() ? Returns the filename of the active workbook ASAPFilePath() ? Returns the path of the active workbook  |
| Bug fixes: | |
| Import | Merge files together in a new file. The ability to import each file on a new sheet is now available. |
| HTML export | removed double ">>" when exporting without a font attribute. |
| Select | Conditional select. Fixed the bug when trying to select text that was "not like" |
| Range | Custom formula error message (hide errors) updated, will now work with in all languages. |
| Text | Make last character super- or subscript will no longer give you an error message if there is a numeric cell in the target selection. |
| Quicknumber | Fixed the error when the leading zero's was less then the number-length. (i.e. 2 leading zero's on 100). |
| Update info | Fixed the "error 13" on Excel 97 machines, when the update information appears. I've also added an option not to hide the update-reminder for a period of 10 days. |
« back
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years