Control how your data will look like on the Preview pane.Ĭonsolidate Worksheets - more advanced and much more convenient.
Choose if you want to split text to columns or to rows.
Split text to columns anywhere in your table and be sure that no data will be overwritten.
Split cells by characters, by mask, or by strings and choose to get the split data parts in columns or rows. 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.
See how your table will look like on the Preview pane.
Add text at the beginning or at the end of the selected cells.
Easily append prefixes, suffixes, strings, characters or symbols.
Remove all Conditional Formatting rulesĮnter any text on the add-in pane and add it to any position in the selected cells.
Reset the text color in the selected range to Automatic.
Change the text alignment to General, bottom.
Thus you can easily delete any custom cell and content formatting. This new pane helps you clear cells to remove number formats, conditional formats, borders, and more.
See how your data will look like on the Preview pane.
Remove everything before or after certain text.
Remove specific number of the first or last characters.
You can remove the first or last characters, find certain characters by their order, or erase everything before or after the entered text. The options in this group are designed to delete characters depending on their location in the selected cells. On this page you'll find the list of all new features. Now Cell Cleaner covers all possible tasks you may have for perfectly clean and error-proof tables. Later it got 4 buttons for trimming extra blanks, removing unwanted characters, converting text and changing case in your worksheets. We have also fixed major and minor bugs and issues in Merge Tables Wizard, Duplicate Remover and Merge Cells.ĭownload Ultimate Suite 2016 Now Cell Cleaner has it all and moreĬell Cleaner started from a small add-in aimed to help you get rid of excess spaces in Excel.
Column Manager is back - enjoy moving columns by drag-n-dropping.
A new cool feature added to Combine Rows.
Combine worksheets in Excel based on column names.
What's new in Consolidate Worksheets Wizard.
3 new buttons and a new feature in Cell Cleaner for Excel.
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 pay close attention to your emails, carefully consider your ideas and advice, and we gladly turn problems into solutions. There is no limit to perfection, so we never stop improving Ultimate Suite.
0 kommentar(er)
