This is now corrected so that it is entered as a number. Text > Delete leading and trailing spaces: If a zero (0) was left as the result in a cell, then it was entered as 'text'. This is now fixed so that it only gets decoded and for example SQL statements that use % are now preserved.įill > Insert current date and time with seconds: The applied number format now shows the seconds too. Web > Remove all HTML tags in the selected cells: Any text after the % character was decoded or removed. Information > Report the formulas used in the worksheets in your workbook: If you had a formula with a large number which was formatted as a date, then this could result in an 'overflow' error. These formulas are now updated too.Ĭopy to clipboard in Windows 8 圆4: Due to a bug in the Windows 8 64-bit edition (only this edition), copying to the clipboard didn't work. A1 to $A1 etc.): Formulas that referenced to a cell with an error or resulted in an error were skipped. This is now fixed.įormulas > Change formula reference style (e.g. Range > Find and/or replace in all sheets: The combination of 'Find/replace in: Range' and 'Look in: Formulas', didn't replace anything. A1 to $A1 etc.): Formulas that referenced to a cell with an error were skipped. Sheets > Change name of selected sheets to selected cell's value: Didn't work if the specified cell on the sheet was hidden. General: A few small improvements and a few spelling corrections.Įxport > Export worksheets as separate files: The combination of a filtered table and excluding hidden rows/columns from the export could result in an error. Setup, Trusted Publishers: During the setup you can now have our company (A Must in Every Office BV) automatically added to the List of Trusted Publishers in ExcelĬustomization, add tools to the Ribbon: The tools from ASAP Utilities are now easier to add to the QAT (Quick Access Toolbar) from Excel 2013/2010/2007 Web > Decode all URL and HTML encoded text: Now also supports (all) Unicode characters (except when you run Excel in Windows 2000).

Text > Replace accented characters (?, ?, ? etc.): Greek accented characters have been added.

Import > Merge and/or import multiple files: New option to choose if the data should be copied/pasted as 'values' or 'formulas'. 'BigBearLake' > 'Big Bear Lake') via ASAP Utilities Options > New tools in development (English only)

NEW: Insert a space before Capital Letters (e.g. NEW: Count and color unique duplicate values via ASAP Utilities Options > New tools in development (English only) Range > Advanced sorting: We've added a new sort option: 'Reverse order' Range > Advanced sorting: We've added a new sort option: 'Value, ignore minus sign (-) in numbers'

Asap utilities for excel 2010 crack