excel data cleaner,ms excel duplicate remover,excel duplicate remover, remove duplicate rows in excel, excel duplicate finder,remove duplicate in excel, excel data cleaner,remove extra spaces in excel

By Category
Email Extractors
Phone Number Extractors
Whois Extractor
Number Generators
Wourd Count Softwares
Excel Addins
MS Word Tools
Unicode Converters
PDF File Converters
Batch Files Printing Tools
Bulk SMS Sender

Products Web Email Extractor Pro Websites Email Extractor Email Extractor Outlook Extractor Outlook Express Email Extractor Outlook 'N' Express Excel to PDF Converter Email Extractor Files Outlook Message Extractor All in One PDF Writer PDF to Image Converter Word to Image Converter Image to PDF Converter Phone Numbers Web Extractor Files Phone Number Extractor PDF to Text Converter Whois Extractor Pen Drive Files Recovery Batch Printing Number Generator Word to PDF Converter PPT to PDF Converter Text to PDF Converter Word Count 'N' Invoice Word FontReplacer Word Highlighter Batch Word Find & Replace Advance Word Find & Replace Line Count 'N' Invoice Office WordCount Standard Office Count 'N' Invoice Excel Word Count Excel Data Cleaner Excel Extra Space Remover Excel Duplicate Manager Excel Text Merger Excel Change Case Excel Number Date Format ExcelatorCTR Parivartak Mangal to Kruti PDF Merger and Splitter
Word Count MiniServicesCustomized SoftwaresSoftware Localization Multilingual WebsitesSpecial OffersDiscounts & PromosQuick Links Home Products Support Order Download Contact Usimportantlinks Privacy Policy
Privacy Policy

Product Catalogue

Data Cleaner Addin for MS Excel v3.0
(Screenshots & Help File)

Excel Data Cleaner is an essential MS Excel Add-In. You can clean your tedious data in excel easily by using its commands which are specially developed to give you the power of automation. You can remove extra spaces, digits, alphabets or any text from selected cells or records. You can also remove, format and count duplicate & unique entries in excel with lightning speed and quality results. It processes thousands of records and cells within a minute which saves your precious time and money. In brief, Data Cleaner is a valuable addin to automate cleaning tasks like duplicate removal, formatting and counting task for Excel with quality and speed. Also Data cleaner works well with Excel 2000, 2003, 2007, 2010.

	Click on Video Tour button to go through an video based tutorial
1: BuyRegistration
2: How it Works

Step 1: Registration
The screen shown as below will be display when you click on "Register It" from "Data Cleaner"menu or Ribon Strip which appears in Excel after installing it.

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 Regnow 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.

Excel Data Cleaner Activation

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.

Download Links

Info

File Size
2.79 MB

License
Purchase

Limitation
15 days trial

Price
$ 29.95

Buy

Support

We Accept

How to Use "Data Cleaner v3.0"

Data Cleaner Menu for Excel 2007 or 2010 :

Data Cleaner Menu for Excel 2000/XP/2003 :

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 above.

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"

Duplicate Preventer is used to prevent further duplicate entries in selected column. To Activate Duplicate Preventer just click on Duplicate Preventer from Data Cleaner 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.1 below.

Fig. 1

Remove All Unique Entries is used to remove all unique entries or records from a selected column. To remove unique records click "Remove all Unique Entries" from Data Cleaner 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. See fig.2 below.

Fig. 2

Remove Duplicate Entries (Keep First) is used to remove duplicate records from a selected column but keep the first one. To remove duplicate records click "Remove Duplicate Entries (Keep First)" from Data Cleaner 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. See fig. 3 below.

Fig. 3

Remove all Duplicate Entries 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 Data Cleaner 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. See fig. 4 below.

Fig. 4

Remove Entries from 1st List exist in the other is used to remove duplicate records from a selected column exist in next selected column, to use this function you have to select two columns. First column should be the list from you want to remove the records and Second column should be the list of words which you want to remove from the First Column. In this function you can only able to Remove Values Only, See Fig. 5.

Fig. 5

Colors : Unique Rows 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. See Fig. 6.

Fig. 6

Colors : Duplicate Rows 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. See Fig. 6.

Count : 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", a Result dialog box appears,
See Fig. 7.

Fig. 7

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", a Result dialog box appears, See Fig. 8.

Fig. 8

Stop Process you can stop any process by clicking on Stop Button, See Fig. 9.

Fig. 9.

Undo and Redo you can undo only your last changes made by Data Cleaner and redo only last undo.About Data Cleaner is open a About Dialog Box, See Fig. 10.

Fig. 10

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.

Screenshots	Single/Multiple Users License
Click on image to enlarge	Select	User License	Cost per User (USD)	Total (USD)
		Single User	$ 29.95	$ 29.95
		3 Users	$ 24.95	$ 74.85
		5 Users	$ 21.95	$ 109.75
		9 Users	$ 19.95	$ 179.55
		11 Users	$ 16.95	$ 186.45
	Single User License Selected: 1 x 29.95 = 29.95 (USD)
	Click on PayPal button to proceed

Start Live Help Chat

LiveZilla Live Help

I bought Website Email Extractor software v3.8 and it worked perfectly for me for extract email id.This is the best and most affordable software on the Net.
~ Andrew Jones

Your software has increased my Excel capability tremendously and it is so cheap that I cannot believe it.
~ Susan

I was stuck with so many Emails on my Outlook and wanted to get all the Email addresses but was not finding the way out, Fortunately I found your unique software which could let extracts emails from my Outlook.
~ Dan Phillips