There is no limit to perfection, so we never stop improving Ultimate Suite. We pay close attention to your emails, carefully consider your ideas and advice, and we gladly turn problems into solutions.
We are happy to let you know that the latest version of Ultimate Suite has got 3 new tools, 1 old tool has been re-implemented and 2 of your favourite add-ins have been improved.
We have also fixed major and minor bugs and issues in Merge Tables Wizard, Duplicate Remover and Merge Cells.
Cell Cleaner started from a small add-in aimed to help you get rid of excess spaces in Excel. Later it got 4 buttons for trimming extra blanks, removing unwanted characters, converting text and changing case in your worksheets. Recently we have added 3 more buttons. Now Cell Cleaner covers all possible tasks you may have for perfectly clean and error-proof tables. On this page you'll find the list of all new features.
The options in this group are designed to delete characters depending on their location in the selected cells. You can remove the first or last characters, find certain characters by their order, or erase everything before or after the entered text.
This new pane helps you clear cells to remove number formats, conditional formats, borders, and more. Thus you can easily delete any custom cell and content formatting.
Enter any text on the add-in pane and add it to any position in the selected cells. Easily append prefixes, suffixes, strings, characters or symbols.
With the new version of Cell Cleaner you can easily bring text from one column into different columns using any character or string as a delimiter. Split cells by characters, by mask, or by strings and choose to get the split data parts in columns or rows.
The new version has got one more option and now you have 6 consolidation variants to choose from. Consolidate Worksheets Wizard has been split into 3 separate buttons to give you an immediate access to your favorite tools. Now it contains Combine Worksheets, Copy Several Sheets and Consolidate Worksheets. New helpful schemes next to the names of specific options won't let you get confused.
Now this smart tool covers all possible tasks you may have for perfectly consolidated tables.
With the help of Combine Worksheets you can join data from columns with the same name even if the column order is different. Also now you can choose if you need to combine data from all columns or if you want to select only specific columns to join and copy to a new sheet.
With this collection of copying options you can join data in a number of ways. Now you first specify how you want to copy your worksheets and then select the sheets for processing.
If you are an active user of the Excel consolidation option, you'll like this tool for its flexibility and intuitive interface. Consolidate worksheets will help you join multiple worksheets into one in a breeze.
In the previous version of Combine Rows Wizard on step 3 you needed to pick a delimiter separately for each column. Now you can select or enter a common delimiter in the Choose delimiter drop-down list and it will be automatically applied to all columns.
A new improved version of the tool is back in Ultimate Suite. If you work with large data tables that have numerous columns, it will help you change their order without copying and pasting one column at a time. Column Manager displays a list of your columns to easily navigate, auto fit and move them by drag-n-dropping. Besides, you can insert and delete new items straight on the add-in pane.
Feel free to download and install the fully-functional trial version of Ultimate Suite to simplify most of the painstaking and time-consuming tasks in Excel.