What's new in Ultimate Suite - the latest changes in our top add-in for Excel

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.

Download Ultimate Suite 2016

Now Cell Cleaner has it all and more

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.
See 7 Cell Cleaner icons in Excel 2016-2007

Remove characters by position

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.

  • Remove specific number of the first or last characters
  • Remove everything before or after certain text
  • See how your data will look like on the Preview pane.

Remove characters in Excel by position

Clear formatting in Excel

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.

  • Reset the number format to General
  • Change the text alignment to General, bottom
  • Shift any font to Calibri 11 pt
  • Remove the current background color
  • Reset the text color in the selected range to Automatic
  • Remove all Conditional Formatting rules
  • Delete borders.

Clear formatting in Excel

Add text to the selected cells

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.

  • Add text at the beginning or at the end of the selected cells
  • Append text after character number
  • Before text or after text.
  • See how your table will look like on the Preview pane.

Add text in Excel

Split text in Excel

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.

  • Split cells by characters
  • Split cells by mask
  • Separate a column by strings
  • Split text to columns anywhere in your table and be sure that no data will be overwritten
  • Choose if you want to split text to columns or to rows.
  • Control how your data will look like on the Preview pane.

Split text in Excel

Consolidate Worksheets - more advanced and much more convenient

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.

See Consolidate Worksheets Wizard buttons in Excel

Combine worksheets in Excel based on column names

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.

Combine worksheets in Excel based on column names - scheme

Copy several worksheets to one

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.

  • Copy sheets in each workbook to one sheet. Place the resulting worksheets to one workbook.
  • Copy data from the selected sheets with the same name to one sheet.
  • Copy the selected worksheets to one workbook.
  • Copy data from the selected worksheets to one sheet.

Consolidate worksheets in Excel

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.

Combine rows - choose a delimiter to apply to all columns at once

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.
Select or enter a common delimiter in the Choose delimiter drop-down list

Column Manager is back - enjoy moving columns by drag-n-dropping

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.
Use Column Manager to move columns by drag-n-dropping

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.

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)