Back to Top
How to remove text & spaces from excel sheets?
Q.1. How to Register, Buy and Activate the software?
  • Register: To register the "Excel Data Cleaner Professional"click on the "Registration" Button and fill the Registeration Detail with the Activation Code.
  • Buy: You have to Buy "Excel Data Cleaner Professional" to get Activation Key . You Can Buy it by Clicking on "Buy" button.
  • Try It:Provide 15 Uses in Trial version of"Excel Data Cleaner Professional".
registration
Q.2. How to use Excel Data Cleaner Professional?
How to clean data in excel sheet:
  1. Excel Data cleaner Addins add to excel menu ribbon after installation.
  2. After that enable macro while open excel software.
  3. Remove the excel data by clicking just text cleaner option on ribbon.
  4. Remove the duplicate excel data by clicking just Duplicate cleaner option on ribbon.
  5. you can count word in excel by clicking on word count option.
  6. Data organizer to clean and organize data.
  7. To know more check video
Excel Data Cleaner Professional
Fig. 1
Q.3. How to Remove all numbers (0-9) in selected cells?

This tool is used to delete all numbers in Selected Cells Values.
Only numbers (0-9) will be deleted from every Selected Cells and leaves only alphabet and other characters. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.

Example: EDCver5@39 become EDCver@

Excel Data Cleaner Professional

Excel Data Cleaner Professional

Excel Data Cleaner Professional

Excel Data Cleaner Professional
Q.4. How to Remove all alphabets (a-z) in selected cells?

This tool is used to delete all alphabets in Selected Cells Values
Only alphabet (a-z/A-Z) will be deleted from every Selected Cells and leaves only numbers and other characters. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.

Example: EDCver5@39 become 5@39

Excel Data Cleaner Professional

Excel Data Cleaner Professional

Excel Data Cleaner Professional

Excel Data Cleaner Professional
Q.5. How to Remove user-defined character in selected cells?

This tool is used to delete characters specified by user in Selected Cells
User can define any characters (numbers, alphabet, special chars, accented chars etc.) to delete from every Selected Cells. This tool works on Constant Values and Formulas will be skipped or calculated to their constant values before deletion.
Example: User defines ‘(@)’ chars to delete from ‘(EDCver5@39)’ result will be EDCver534

Excel Data Cleaner Professional
Q.6. How to Remove all UPPER CASE characters in selected cells?

This tool is used to delete All Caps characters in Selected Cells.
Only All Caps (A-Z) will be deleted from every Selected Cells and leaves only lower case chars, numbers and other characters. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.
Example: EDCver5@39 become ver5@39

Excel Data Cleaner Professional
Q.7. How to Remove all LOWER CASE characters in selected cells?

This tool is used to delete all lower case characters in Selected Cells.
Only lower case (a-z) will be deleted from every Selected Cells and leaves only All Caps chars, numbers and other characters. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.
Example: EDCver5@39 become EDC5@39

Q.8. How to Remove all Instance of spaces in selected cells?

This tool is used to delete all instances of spaces in Selected Cells.
The all instance of spaces (‘ ‘) will be deleted from every Selected Cells and leaves not even a single space. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.

Example: (EDC ver  5  @  39   ) become (EDCver5@39)
Q.9. How to Remove Leading and trailing spaces in selected cells?

This tool is used to delete leading and trailing spaces in Selected Cells.          
The all leading and trailing spaces (‘ ‘) will be deleted from every Selected Cells. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.         

Example: (  EDC ver  5  @  39   ) become (EDC ver  5  @  39)
Q.10. How to Remove all Excessive Spaces in Selected Cells?
This tool is used to delete all extra spaces in Selected Cells.          
The all extra spaces (‘   ‘) will be deleted from every Selected Cells and leaves a single space between words or characters. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.         
Example: (  EDC ver  5  @  39   ) become (EDC ver 5 @ 39)
Q.11. How to Remove/Replace all text before and after nth Character(s)?
Remove/Replace all text before nth Character(s):
This tool is used to delete or replace all text before nth character(S).          
The nth character(s) is any given character or series of characters which will be searched and if found all leading characters before nth chars of that cell will be deleted or replaced. This tool works on Constant Values and Formulas will be skipped.         
Example (Deletion): Cell Text:’EDCver5@39’, nthChars:’ver5’ result:’ver5@39’
Example (Replace):
Replace Text:’ExcelDataCleaner’, result:’ExcelDataCleanerver5@39’

Remove/Replace all text after nth Character(s):

This tool is used to delete or replace all text after nth character(S).          
The nth character(s) is any given character or series of characters which will be searched and if found all trailing characters after nth chars of that cell will be deleted or replaced. This tool works on Constant Values and Formulas will be skipped.         
Example (Deletion): Cell Text:’EDCver5@39’, nthChars:’ver5’ result:’EDCver5’
Example (Replace): Replace Text:’@11’, result:’EDCver5@11’
Q.12. How to Remove/Replace X nos. of Character(s) before and after nth Character(s)?
Remove/Replace X nos. of Character(s) before nth Character(s):
This tool is used to delete or replace X number of character(s) before nth character(S).          
The nth character(s) is any given character or series of characters which will be searched and if found X number of character(s) which is specified by user, before nth Characters will be deleted or replaced. This tool works on Constant Values and Formulas will be skipped.         
Example (Deletion): Cell Text:’EDCver5@39’, nthChars:’ver5’ X Nos.:2 result:’Ever5@39’

Example (Replace): Replace Text:’Data Cleaner’, result:’EDataCleanerver5@39’

Remove/Replace X nos. of Character(s) after nth Character:

This tool is used to delete or replace X number of character(s) after nth character(S).          
The nth character(s) is any given character or series of characters which will be searched and if found X number of character(s) which is specified by user, after nth Characters will be deleted or replaced. This tool works on Constant Values and Formulas will be skipped.         
Example (Deletion): Cell Text:’EDCver5@39’, nthChars:’ver5’ X Nos.:1 result:’EDCver539’
Example (Replace): Replace Text: ‘at’, result:’EDataCleanerver5at39’
Q.13. How to Remove/Replace X nos. of Leading and Trailing Character(s)?
Remove/Replace X nos. of Leading Character(s):

This tool is used to delete or replace leading X number of character(s) in Selected Cells.          
The Leading X number of character(s) which is specified by user will be deleted or replaced. This tool works on Constant Values and Formulas will be skipped.         
Example (Deletion): Cell Text:’EDCver5@39’, X Nos.:2 result:’Cver5@39’
Example (Replace): Replace Text: ‘Excel Data’, result:’ExcelDataCver5@39’

Remove/Replace X nos. of Trailing Character(s) :

This tool is used to delete or replace trailing X number of character(s) in Selected Cells.          
The Trailing X number of character(s) which is specified by user will be deleted or replaced. This tool works on Constant Values and Formulas will be skipped.         
Example (Deletion): Cell Text:’EDCver5@39’, X Nos.:2 result:’EDCver5@’
Example (Replace): Replace Text:’11’, result:’EDCver5@11’
Q.14. How to Remove Duplicate Entries (Keep Fist)?
This tool is used to delete all duplicate entries in Selected Column but keep one record. 

All duplicate entries will be deleted from selected column and leaves only a single entry each of them. You can delete text entries or complete rows 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 Professional

Excel Data Cleaner Professional

Excel Data Cleaner Professional

Excel Data Cleaner Professional
Q.15. How to Remove All Duplicate Entries?
Remove All Duplicate Entries:
This tool is used to delete all duplicate entries in Selected Column.         
All duplicate entries will be deleted from Selected column and leaves not even a single entry. You can delete text entries or complete rows when duplicate found. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.

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.
Q.16. How to use Duplicate Preventer ?
This tool is used to prevent duplicate entries in Selected Column.  
All duplicate entries will be prevented in Selected column and show message if you try to enter duplicate text.
Q.17. How to Remove all Unique Entries?
This tool is used to delete all unique entries in Selected Column. 
All unique entries will be deleted from Selected column and leaves not even a single unique entry. You can delete text entries or complete rows when unique entry found. This tool works on Constant Values and Formulas can be skipped or calculated to their constant values before deletion.
Q.18. How to Remove Empty Rows and column in Selection ?
A Collection of Tools to Organize Data.
Remove Empty rows in Selection:
This tool is used to delete all empty rows in selection.

Remove Empty column in Selection:
This tool is used to delete all empty columns in selection       
Excel Data Cleaner Professional

Excel Data Cleaner Professional

Excel Data Cleaner Professional
Q.19. How to Remove Empty Sheets in Workbook and All Objects in Active sheet?
Remove Empty Sheets in Workbook:
This tool is used to delete all empty worksheets in workbook

Remove All Objects in Active sheet:
This tool is used to delete all objects from Active Sheet
Q.20. How to Change to UPPER CASE, Lower Case, Proper Case and Sentence Case?
Change to UPPER CASE:
This tool is used to convert all text of selected cells into ALLCAPS.         
Example: ‘edc ver5’,’Edc Ver5’ will be converted to ‘EDC VER5’

Change to Lower Case:
This tool is used to convert all text of selected cells into lower case.
Example: ‘EDC VER5’,’Edc VER5’ will be converted to ‘edc ver5’

Change to Proper Case:
This tool is used to convert all text of selected cells into Proper Case. 
Capitalize first character of each word in Selected cells.
Example: ‘EDC VER5’,’edc ver5’ will be converted to ‘Edc Ver5’

Change to Sentence Case:
This tool is used to convert all text of selected cells into Sentence Case.
Capitalize first character of first word in Selected cells.
Example: ‘EDC VER5’,’edc ver5’ will be converted to ‘Edc ver5’
Q.21. How to Color each nth Row, Duplicate Rows and Unique Rows in selection?
Color each nth Row in selection:
This tool is used to color each nth row in selection         
nth row is specified by user.
Example: if nth row : 2, 2,4,6,8 rows will be colored.

Color Duplicate Rows in Selection:
This tool is used to color all duplicate rows in selection.

Color Unique Rows in Selection:
This tool is used to color all unique rows in selection.
Q.22. How to Convert Columnar Data into Tabular Form?

This tool is used to transpose all columnar data into tabular form.

Excel Data Cleaner Professional
Push Notification Service
chat Online Help
LiveZilla Live Help
formGet a Free Quote
X discount