logo ASAP Utilities

Receive our newsletter

Get an email when a new version of ASAP Utilities is released

RSS Feed

The new version will be announced in our news RSS feed.

Changes in version 5.1 - January 27, 2014

Date: Januari 27, 2014 (last updated on Februari 14, 2014)
reference id: QA0263

Finished

On January 28, 2014 the new version 5.1 is released. Download

Update: Version 4 and 5

Your current license will work with all 4.x ánd 5.x versions.
All existing 4.x customers will get 5.x free of charge. You can use the same license details.

New features and improvements

  • Range » Advanced sorting...
    We've added a new sort option: "Value, ignore minus sign (-) in numbers"
    This will sort your numbers ignoring the negative sign.
    Positives and negatives are sorted as the same, which can be helpful for reconciliation (accounting).
    For example this allows you to sort your amounts like this:
       -668.00
        668.00
       -995.00
        995.00
      -1187.00
       1187.00
       1657,00
      -1741.00
       1741.00
    Sort your numbers ignoring the negative sign
  • Range » Advanced sorting...
    We've added a new sort option: "Reverse order"
    This will reverse the order of the data, independent of the values in the cells.
    You can use it to flip entire rows vertically or columns horizontally.
    This can be helpful in for example the following scenario:
    I've a long column of numbers in excel which I need to flip around or invert. I can't use Excel's sort function as it only sorts it in ascending or descending order but I need to reverse the order of the numbers
    so that bottom becomes top and top becomes bottom for example.

    Sort your data in reverse order
  • NEW: Count and color unique duplicate values
    via ASAP Utilities Options » New tools in development (English only)
    Count and color the duplicate values in your selection where each set of duplications gets its own color.
    (As long as there are enough distinct colors available to see the difference. If there are too many sets of duplicates then you will be notified).
    Count and color unique duplicate values: Each set of duplicates gets its own color
  • NEW: Insert a space before Capital Letters (e.g. 'BigBearLake' > 'Big Bear Lake')
    via ASAP Utilities Options » New tools in development (English only)
    This will put a space in front of Capital letters in the text in your selected cells.
    For example "NewYork" becomes "New York".
    This tool is smart enough to detect when a space should be inserted and when not.
    A space is only inserted before uppercase characters when it is not already preceded by a space and also when it is not preceded by any of the following characters: - " ' ( | = ` [ { <
    Insert a space before Capital Letters (e.g. 'BigBearLake' > 'Big Bear Lake')
  • Import » Merge and/or import multiple files...
    New option to choose if the data should be copied/pasted as 'values' or 'formulas'.
    If you choose 'formulas' then any formulas will be copied as they are, just like a regular 'copy and paste'. This has been how it always was in this tool, before you could make this choice.
    If you choose 'values' then the values will be used from your source data, similar to Copy > Paste special > Values
    New option to choose if you create a new worksheet for each file: 'Import page and print settings'
    New: Paste as values or (values and) formulas and/or import the page and print settings
     
  • Text » Replace accented characters (á, ë, ñ etc.)...
    Greek accented characters have been added.
    Replace accented characters - Now supports Greek accented characters too
  • Web » Decode all URL and HTML encoded text
    Now also supports (all) Unicode characters (except when you run Excel in Windows 2000).
    Decode all URL and HTML encoded text now also supports (all) Unicode characters.
  • 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.
    Some people have their security settings set to only allow macros run by Trusted Publishers, and then this can help.
    For reference, Microsoft: Add, remove, or view a trusted publisher
    Add our company (A Must in Every Office BV) to the list of Trusted Publishers
  • Customization, 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. Besides the existing way to add them to your favorites menu, we think that this might help to even further speed up your workflow.
    You can do on two ways
    #Method 1 By right-clicking on a tool in the menu and then choosing "Add to Quick Access Toolbar":
    Right-click - Add to Quick Access Toolbar (QAT)

    #Method 2 via File > Options > Quick Access Toolbar (only in Excel 2010/2013):
    Customize the Quick Access Toolbar with tools from ASAP Utilities

  • General
    A few small improvements and a few spelling corrections.

Bug fixes and improvements






« back

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook