Download

List Cleanser for Microsoft® Excel® is utility that works with Excel files and helps you to clean your data.

With various operations like Delete, Copy, Clear, Clear Contents you can easily filter the lists using various selection criteria reduce the lists/data to only those you are interested in.

If your lists contain information that you do not want to work with or you are not interested in, use this utility to save your time and reduce the List a Subset list you want to work with.

Features:

Here are various operations with you can perform on your Excel® Data/lists.

Delete those that
Only keep those that
Select those that
Copy those that
Clear Contents from those
Clear those

And you have the following criteria to select the right subset of the list you want to operate on

Contain
Do not contain
Are Blanks
Are only Text
Are only Numeric
Have Errors
Are Equal to
Are not Equal to
Are Greater than
Are Greater than or Equal to
Are Less than
Are Less than or Equal to
Begin with
Do not Begin with
End with
Do not End with

This Add-in works with the selected range of any active Excel Workbook and performs the filter criteria using the first column of the selected range.

Also, unlike other VBA and Macro operations you have the flexibility to Undo the last operation performed by the add-in.
This is to ensure you do not lose your data while working with this add-in for Excel®