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

Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard