 |
|
Data Cleaner
Microsoft® Excel® 97, 2000, 2002, 2003, 2007, and 2010
- Save time by automating your editing
- Eliminate manual errors
- Create "edit rules" that you can apply over
and over again
- Remove excess blanks, html "spaces", and
non-keyboard characters
- Convert text to any case
- Convert "text" numbers to real numbers
|
Data Cleaner
adds must have features to Excel that eliminate the manually eidting or cleaning
of data. Save hours of time and ensure that all your
modifications are done right. The Data Cleaner adds the
following features:
-
The replace/ modify text feature works off of lists you build
so that you can easily modify data. For example,
your data can contain the
entry "ABC Corporation" and you want to change it to "ABC Corp". You can
have hundreds or thousands of such data "pairs". Also you have a number of
search and replace options to provide the control you need to modify your
data.
-
The change case feature changes the case on your words to
all upper case, proper case,
capitalize just the first word in an entry,
or convert all entries to lower case.
-
The convert "text" numbers to numbers feature converts cell
entries that look like numbers but behave like text strings back into numbers.
This problem is often encountered when you import data from other
programs.
The remove non-keyboard characters feature is an easy way to remove the small boxes and other strange characters that can end up in your data if opened from another computer or a web page.
If your data has soft or hard returns in it, the option to remove such characters is easy to use - just select the range to be modified and run the option. You have the option to just remove the returns or convert to a space or any character.
The remove any characters feature allows you to specify the characters to be removed and retained in your cell entries. You select just the characters you want to retain and click the remove button. Quick select buttons make selection of keyboard characters easy.
|
Order online from our secure service.
Get delivery in
minutes!
|
|
US $49.95
|
Customers who viewed the Data Cleaner also viewed:
|
Order online from our
secure service
Get delivery in minutes!
Order Risk Free
Money back guarantee
if not satisfied
Buy individually or
save by buying the Productivity Suite
|
