Excel Data Cleaner

Excel Data Cleaner

$34.95

Excel Data Cleaner is an extraordinary tool that can remove all kinds of tedious data from excel files. The software can mechanize all extensions of excel like .xls, .xlsm, .xlsx, etc. in infinite number.

Product Description

You can remove duplicates & unique entries like numbers, digits, letters alphabets, etc. from Excel sheets & files. These duplicate & unique entries can be highlighted with color so that they can be identified easily.

Along with that you can remove spaces from excel files such as leading, trailing & excessive spaces from Excel sheets & workbooks. The tool also has option to remove gaps from cells & rows of the sheets & files. All the components furnished in this tool make the work easier for the user.

This excel cleaning tool is flexible to work with all versions of MS Excel. If you have installed 2013, 2010 or 2007 it will work with all of them. This amazing software is perfect in cleaning excel files taking the least time. These things make it the best excel cleaning tool at this rate.

  • Remove unwanted data from excel files in bulk.
  • Users can dump all extensions of Excel i.e. .xls, .xlsm, .xlsx, etc. ion ample amount.
  • It can remove duplicates of alphabets, letters and even alpha-numeric characters.
  • Leading, trailing & even excessive space can be removed with the given options.
  • The tool can remove data from rows, columns, sheets & even files of excel.
  • It is adaptive to all versions of MS Excel i.e. 2013, 2010 & 2007.

Q.1. How to Register, Buy and Activate the software?

Register : for registering the “Data Cleaner” please send us your “Customer Id “ from the above window by click “Get Registration Key” button. After confirmation of payment we provide you an “Activation code” that registers your “Data Cleaner”.

Buy: To buy “Data Cleaner” please click “Buy” button in the above window click on your payment gateway and chose Paypal ,Avangate or you can even send to us cheque/DD or bank transfer in favour of “Technocom” payable at New Delhi and you can ask the details by sending us a email.

Activate : Please enter your name in “Register to : ” textbox and “Registration Key” which we provide you when you have bought the tool in the activation code text field and click Activate button.

Excel Data Cleaner Activation

Q.2. How to use Data Cleaner?

Data Cleaner is easy to use tool for MS Excel. After installing it, you can see a separate menu in Excel 2000/XP/2003 or a separate Ribon strip in Excel 2007/2010 as shown below.
Data Cleaner Menu for Excel 2007 or 2010 :

Duplicate Remover Menu

Duplicate Remover Menu

Data Cleaner Menu for Excel 2000/XP/2003:

Excel Data Cleaner for Excel

Remove all Numeric is used to remove all digits from selected cells. E.g. 0abc123 = abc
Remove all Alphabets is used to remove all alphabets from selected cells. E.g. 0abc123 = 0123
Remove user-defined Chars is used to remove any text specified by user from selected cells. You can specify any text value E.g. Special Chars like (@#$^&!-+*|\/?><.,`~[]{}_=), Digits (0-9), alphabets(a-z, A-Z).
Remove all spaces is used to remove all spaces even a single space from selected cells.
E.g.: ”    0   a b c   12 3   ” = “0abc123”
Remove all Leading/Trailing Spaces is used to remove all leading and trailing spaces from selected cells. E.g.: ”    0   a b c   12 3   ” = “0   a b c   12 3”
Remove all Excessive Spaces is used to remove all leading, trailing and excessive spaces from selected cells. E.g.: ”    0   a b c   12 3   ” = “0 a b c 12 3”

Q.3. How to Remove Duplicate Entries (Keep Fist)?

This tool is used to delete all duplicate entries in Selected Column but keep one record.
To remove duplicate records click “Remove Duplicate Entries (Keep First)” from Duplicate Manager Menu. Choose “Remove Values Only”, if you want to remove only cell content or choose “Remove Entire Rows”, if you want to remove entire row from the list.

Excel Data Cleaner Remove Duplicate in MS Excel

Q.4. How to Remove All Duplicate Entries?

It is used to remove all the duplicate records from a selected column, even from first instance. To remove all duplicate records click “Remove all Duplicate Entries” from Duplicate Manager Menu. Choose “Remove Values Only”, if you want to remove only cell content or choose “Remove Entire Rows”, if you want to remove entire row from the list.

Excel Data Cleaner Remove Duplicate in MS Excel

Remove Duplicate Entries from 1st Column Exist in 2nd Column:
This tool is used to delete all duplicate entries from 1st Column exist in 2nd Column.
All duplicate entries will be deleted from 1st column exist in 2nd column and leaves only a single entry each of them. You can delete only text entries when duplicate found. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.

Excel Data Cleaner

Q.5. How to use Duplicate Preventer ?

Duplicate Preventer is used to prevent further duplicate entries in selected column. To Activate Duplicate Preventer just click on Duplicate Preventer from Duplicate Manager menu, a dialog box appears, just click to Apply button to Activate it or choose Deactivate Preventer to deactivate it and press Apply button. see fig below.

Duplicate Preventer

Q.6. How to Remove all Unique Entries?

It is used to remove all unique entries or records from a selected column. To remove unique records click “Remove all Unique Entries” from Duplicate Manager Menu. Choose “Remove Values Only”, if you want to remove only cell content or choose “Remove Entire Rows”, if you want to remove entire row from the list.

Excel Data Cleaner Remove Duplicate in Excel

Q.7. How to Color Duplicate Rows in Selection?

It is used to highlight duplicate cells of a selected column, it also shows how many cells are duplicate and highlighted in a selected column, to run this command simply click on Colors then “Duplicate Rows”, a color dialog box appears, choose your color and press ok.

Excel Data Cleaner Highlight Unique Rows in Excel

Q.8. How to Color Unique Rows in Selection?

It is used to highlight unique cells of a selected column, it also shows how many cells are unique and highlighted in a selected column, to run this command simply click on Colors then “Unique Rows”, a color dialog box appears, choose your color and press ok.

Excel Data Cleaner  Highlight Unique Rows in ExcelExcel Data Cleaner

Q.9. How to Count Duplicate Rows and Unique Row?

Unique Rows is used to count unique cells in a selected column, to know how many cells are unique in a selected column, simply click on Count then “Unique Rows”.

Excel Data Cleaner Excel Data CleanerExcel Data Cleaner

Count Duplicate Rows is used to count duplicate cells in a selected column, to know how many cells are duplicate in a selected column, simply click on Count then “Duplicate Rows”.

Excel Data Cleaner Excel Data Cleaner

Stop Process you can stop any process by clicking on Stop Button.

Excel Data Cleaner

Undo and Redo you can undo only your last changes made by Data Cleaner and redo only last undo.
Turn Off Data Cleaner is used to shut down Data Cleaner once you off it you can only see Data Cleaner when you Launch it from Desktop Shortcut or Start Menu.

Reviews

There are no reviews yet.

Be the first to review “Excel Data Cleaner”