Back to Top
How to remove alphabets from excel cell?
Q.1. How to Register, Buy and Activate the software?
  • Register: To register the "Excel Text Cleaner" click on the "Get Activation Key" Button and fill the Registeration Detail with the Activation Code.
  • Buy: You have to Buy "Excel Text Cleaner" to get Activation Key . You Can Buy it by Clicking on "Buy online" button.
  • Try It: Provide 50 Uses in Trial version of "Excel Text Cleaner".
registration
Q.2. How to clean text in excel sheet?
  1. Excel text 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 Text cleaner option on ribbon.
  5. you can count word in excel by clicking on count tool option.
  6. Data organizer to clean and organize data.
  7. To know more check video
Excel Text Cleaner
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 Text Cleaner


Excel Text Cleaner

Excel Text Cleaner
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 Text Cleaner

Excel Text Cleaner

Excel Text Cleaner
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 Text Cleaner
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 Text Cleaner
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 Count Words from Active Sheet?
A collection of tools to show statistics of Workbook. This tool is used to show statistics of Current Active Sheet.
Count Active Sheet : If you want to Count only Current Active Sheet Content, Just click it to open “Word Count – Statistics”Dialog Box. (See Fig. 2)
Excel Text Cleaner

Excel Text Cleaner
Fig .2
Count all Worksheet:
This tool is used to show statistics of All Worksheets of Workbook. Excel Word Count Also display statistics for Visible Sheets and Hidden Sheets of a Workbook. Count All Sheets : If you want to Count All Sheets of Active Workbook, Just click it to open “Word Count – Statistics” Dialog Box. (See Fig. 3)
Excel Text Cleaner
Fig .3
Q.15. How to Count Words in selected cellls?
Count in Selected Cells:
This tool is used to show statistics of Selected Cells. Excel Word Count Also display statistics for Visible Sheets and Hidden Sheets of a Workbook. Count Selected Cells : If you want to Count only Selcted cells in a sheet, Just click it to open “Word Count – Statistics” Dialog Box. (See Fig. 4)
Excel Text Cleaner
Fig .4
Excel Word Count Also display statistics for Visible Sheets and Hidden Sheets of a Workbook.Word Count – Statistics : Once you open Word Count – Statistics dialog box, you can click on Radio Button to get statistics for Active Sheet, Active Workbook & Selected Cells.

Excel Word Count is introducing two new features which can help you to Count Words & Custom Lines via Formula. First is “=WORDS()” formula, just type this formula in any cells and select range of cells to get the word count.
Q.16. How to Count Duplicate Rows in Selection?
Count Duplicate Rows in Selection:
This tool is used to count duplicate rows in selection.
Excel Text Cleaner

Excel Text Cleaner
Q.17. How to Count Unique Row in Selection?
Count Unique Row in Selection:
This tool is used to count unique rows in selection.
Excel Text Cleaner
Find And Replace Combo Offer
Excel Find and Replace + PowerPoint Find and Replace + Batch Word Find and Replace
Excel Find and Replace Batch PowerPoint Find & Replace Batch Word Find and Replace
(Find & Replace and Highlight each word in MS EXCEL in Batch.) (Find & Replace and Formatting Tool for ppt,pptx,pptm.) (Find & Replace and Highlight each word in MS WORD in Batch.)
cards
Offer Price
US $ 119.00 Only
(save upto 40$ )
buy now
Push Notification Service
chat Online Help
LiveZilla Live Help
formGet a Free Quote
X discount