It's now possible to look for matching strings with wildcards when using the Advanced Find and Replace tool. You just need to select the Use wildcards checkbox.
After merging cells, the add-in will keep your Excel table. It won't convert it into a range.
You can now opt for applying the AVERAGEA function when processing your data with the Merge Duplicates, Merge Cells, Transpose by Key Columns, or Cross-Sheet Operations tool.
In response to your feedback, we've adjusted the Merge Duplicates, Merge Cells, Split Table, and Transpose by Key Columns tools to process your data correctly even if Excel shows hashtags because columns are simply not wide enough.
Thanks to your feedback, we've changed the behavior of the Merge Duplicates, Merge Cells, and Transpose by Key Columns tools. If you apply an aggregate function to a range that contains an empty column or row and select the Skip empty cells option, empty cells are now ignored as expected.
We've resolved some issues in Combine Sheets, Consolidate Sheets, Copy Sheets, Compare 2 Sheets, Remove Duplicates, Extract Text, Substring Tools, Date & Time Wizard, Date Picker, Fill Blank Cells, Find Broken Links, Count Characters, Cross-Sheet Operations, and Notes Manager.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!
