Excel Utilities
Price $ 74.00

OS: Window 8 and 7/ Vista/ 2003/ XP/ 2000/NT
Version 2.3.0
Publisher: Technocom
Excel Utilities

Interactive Tour - Video Tour

How to remove hyperlink in excel from multiple cells?


Interactive Tour (1/39) - Registration/Buy/Activate:

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

  • Registration window will be display in the un-registered version every time.

    Register : To register the "Excel Utilities" click on the "Activate Application" Button and fill the Registeration Detail with the Activation Code.

    Buy
    : You have to Buy "Excel Utilities" to get Activation Code. You Can Buy it From our Site by Clicking on "Buy Activation Key" button.

    Try It : You can use demo version of "Excel Utilities" by clicking on "Continue Trial" Button.


  • Excel Utilities Excel Utilities

    Interactive Tour (2/39) - Use Excel Utilities Software:

    Q 2 . How to use Excel Utilities Software?

    There is many Options in Excel Utilities software given Below. To apply First select the command and then press Run Command button to aaply. After apply the command undo is not possible thats mean that the undo command is not working.

    Note: You have to need .Net Framework 4.0 in your system and Visual Studio (VSTO) Run Time. If these softwares not installed in your system the Excel Utilities software not working properly. The .Net Framework 4.0 is automatically installed to your system if it is not installed in your system but you have to download Visual Studio (VSTO) software for 64bit window from given link below.
    Download Visual Studio (VSTO)



    Excel Utilities

    Interactive Tour (3/39) - use Change Case Option:

    Q.3. How to use Change Case Option ?

    There is many Options in Change Case given Below
    1. Lower case
    2. Proper Case
    3. Sentence case
    4. UPPER CASE

    lower case

    This tool is used to convert all text of selected cells into Lower case.
    Example:
    Macro, EXCEL >> macro, excel



    Excel Utilities

    Excel Utilities

    Interactive Tour (4/39) - change Proper Case in excel:

    Q.4. How to change Proper Case in excel?

    This tool is used to convert all text of selected cells into Proper case. Capitalize first character of each word in selected cells.
    Example:
    marketing tools >> Marketing Tools
    Excel Utilities

    Interactive Tour (5/39) -change Sentence case in excel:

    Q.5. How to change Sentence case in excel?

    This tool is used to convert all text of selected cells into Sentence case. Capitalize first character of first word in selected cells.
    Example:
    marketing tools >> Marketing tools
    Excel Utilities

    Interactive Tour (6/39) - Change all selected text to UPPER CASE or Capital Letters in excel:

    Q.6. How to Change all selected text to UPPER CASE or Capital Letters in excel?

    This tool is used to convert all text of selected cells into AllCaps.
    Example:
    marketing tools >> MARKETING TOOLS
    Excel Utilities

    Interactive Tour (7/39) - use Clean Text Option:

    Q.7. How to use Clean Text Option?

    There is many Options in Clean Text given Below
    1. Remove all Extra spaces
    2. Remove all Leading spaces
    3. Remove all Trailing spaces
    4. Remove all Leading and Trailing spaces
    5. Remove Non-Printable Characters
    Excel Utilities

    Interactive Tour (8/39) -Remove all Extra spaces in Excel:

    Q.8. How to Remove all Extra spaces in Excel?

    The all extra sapces ("  ") will be deleted from every selected cells and leaves a single space between words or characters. This tool works on Constant values.
    Example:
    (  EDC  ver 5  @  39  ) >> (EDC ver 5 @ 39)
    Excel Utilities

    Interactive Tour (9/39) -Remove all Leading spaces in Excel:

    Q.9. How to Remove all Leading spaces in Excel?

    The all Leading sapces ("  ") 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 39  ) >> (EDC ver 39 )

    Interactive Tour (10/39) -Remove all Trailing spaces in Excel:

    Q.10. How to Remove all Trailing spaces in Excel?

    The all Trailing sapces ("  ") 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:
    (  This is best Excel Addins  ) >> ( This is best Excel Addins)

    Interactive Tour (11/39) -Remove all Leading and Trailing spaces in Excel:

    Q.11. How to Remove all Leading and Trailing spaces in Excel?

    The all Leading and Trailing sapces ("  ") 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:
    (  This is best Excel Addins  ) >> (This is best Excel Addins)

    Interactive Tour (12/39) -Remove Non-Printable Characters in Excel:

    Q.12. How toRemove Non-Printable Characters in Excel?

    This command is used to remove all non-printable characters like paragraph, line break, section, tab, non-width joiner and other non visible characters from selected cells.
    Example:
    Paragraph, Return Carriage, Tab and Section Mark

    Interactive Tour (13/39) -Use Clean Format option:

    Q.13. How to use Clean Format option?

    There is many Options in Clean Format given Below

    1. Remove all Hyperlinks
    2. Remove all Comments
    3. Remove all Font Color
    4. Remove all Cell Color
    5. Remove all Border
    6. Remove all Applied Format
    Excel Utilities

    Interactive Tour (14/39) -Remove all Hyperlinks in Excel:

    Q.14. How to Remove all Hyperlinks in Excel?

    Remove Links from cells.
    This command is used to remove all hyperlink from selected cells after applying this command you will not able to navigate through linked Cells.

    Interactive Tour (15/39) - Remove all Comments in Excel:

    Q.15. How to Remove all Comments in Excel?
    Remove Comment Box from cells.
    This command is used to remove all comments from selected cells. Comment box will not appear after applying this command on hover of mouse pointer on cells.

    Interactive Tour (16/39) - Remove all Comments in Excel:

    Q.16. How to Remove all Comments in Excel?
    Remove Comment Box from cells.
    This command is used to remove all comments from selected cells. Comment box will not appear after applying this command on hover of mouse pointer on cells.

    Interactive Tour (17/39) - Remove all Cell Color in Excel:

    Q.17. How to Remove all Cell Color in Excel?
    Remove Background Color of cells.
    This command is used to remove all bg color of Selected Cells.

    Interactive Tour (18/39) - Remove all Border in Excel:

    Q.18. How to Remove all Border in Excel?
    Remove all borders from cells.
    This command is used to remove all applied border from selected cells.

    Interactive Tour (19/39) - Use Remove Text option:

    Q.19. How to use Remove Text option?
    There is many Options in Remove Text given Below
    1. Remove all Numeric [0-9]
    2. Remove all Non-Numeric
    3. Remove all Alphabets [a-z, A-Z]
    4. Remove all Non-Alphabets
    5. Remove all Alphanumeric [0-9, a-z, A-Z]
    6. Remove all Non-Alphanumeric
    7. Remove all Upper Case [A-Z]
    8. Remove all Lower Case [a-z]
    9. Remove all User-Defined Characters
    Excel Utilities

    Interactive Tour (20/39) - Remove all Numeric [0-9] values in Excel:

    Q.20. How to Remove all Numeric [0-9] values in Excel?
    Only numbers (0-9) will be deleted from every Selected Cells and leaves only alphabet_other characters. This tool works on Constant values and Formulas can be skipped or calculated to their constant values before deletion.
    Example:
    (EDC ver@ 39) >> (EDC ver@)

    Interactive Tour (21/39) - Remove all Non-Numeric characters in Excel:

    Q.21. How to Remove all Non-Numeric characters in Excel?
    This command is used to remove all non-numeric characters from selected cells. It will leave only numeric characters[0-9].
    Example:
    EDC ver5@39 >> 539

    Interactive Tour (22/39) - Remove all Alphabets [a-z, A-Z] characters in Excel:

    Q.22. How to Remove all Alphabets [a-z, A-Z] characters in Excel?
    Only alphabet (a-z/A-Z) will be deleted from every Selected Cells and leaves only numbers_other 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) >> (  5@39)

    Interactive Tour (23/39) - Remove all Non-Alphabets characters in Excel:

    Q.23. How to Remove all Non-Alphabets characters in Excel?
    This command is used to remove all non-alphabet characters from selected cells. It will leave only alphabet characters[A-Z] and [a-z].
    Example:
    EDC ver5@39 >> EDC ver

    Interactive Tour (24/39) - Remove all Alphanumeric [0-9, a-z, A-Z] characters in Excel:

    Q.24. How to Remove all Alphanumeric [0-9, a-z, A-Z] characters in Excel?
    Only alphabet and numeric (a-z/A-Z/0-9) will be deleted from every Selected Cells and leaves only special characters_other 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) >> (  @)

    Interactive Tour (25/39) - Remove all Non-Alphanumeric in Excel:

    Q.25. How to Remove all Non-Alphanumeric in Excel?
    This command is used to remove all non-alphanumeric characters from selected cells.
    Example:
    (EDC ver@ 39) >> EDCver39

    Interactive Tour (26/39) - Remove all Upper case and Lower case characters in Excel:

    Q.26. How to Remove all Upper case and Lower case characters in Excel?

     

    Remove all Upper Case [A-Z]

    Only Allcaps (A-Z) will be deleted from every Selected Cells and leaves only lower case characters, numbers_other characters. This tool works on Constant values and Formulas can be skipped or calculated to their constant values before deletion.
    Example:
    (EDC ver@ 39) >> ( ver@ 39)

    Remove all Lower Case [a-z]

    Only lower case (a-z) will be deleted from every Selected Cells and leaves only Allcaps characters, numbers_other characters. This tool works on Constant values and Formulas can be skipped or calculated to their constant values before deletion.
    Example:
    (EDC ver@ 39)>>(EDC @ 39)

    Interactive Tour (27/39) - Remove all User-Defined Characters in Excel:

    Q.27. How to Remove all User-Defined Characters in Excel?
    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 can be skipped or calculated to their constant values before deletion.
    Example:
    User defines "(@)" chars to delete from "(EDC ver5@ 39)" result will be EDC ver5 39

    Interactive Tour (28/39) - use Replace Text option:

    Q.28. How to use Replace Text option?
    There is many Options in Replace Text given Below
    1. All Text Before nth Character(s)
    2. All Text After nth Character(s)
    3. X no. of chars Before nth character
    4. X no. of chars After nth character
    5. X no. of Leading character(s)
    6. X no. of Trailing character(s)
    Excel Utilities

    Interactive Tour (29/39) - Replace All Text Before nth Characters in Excel:

    Q.29. How to Replace All Text Before nth Characters in Excel?
    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 can be skipped.

    Interactive Tour (30/39) - use Insert Text Option:

    Q.30. use Insert Text Option?

    There is many Options in Insert Text given Below

    1. Leading Characters
    2. Trailing Characters
    3. Before nth character(s)
    4. After nth character(s)
    Excel Utilities

    Interactive Tour (31/39) - add text to the beginning of all cells in Excell:

    Q.31. How toadd text to the beginning of all cells in Excel?
    Insert Leading Characters
    This command is used to insert or prefix user defined character in Selected Cells.

    Interactive Tour (32/39) - add text to the end of all cells in Excel:

    Q.32. How to add text to the end of all cells in Excel?
    Insert Trailing Characters
    This command is used to insert or prefix user defined character in Selected Cells.

    Interactive Tour (33/39) - Remove Empty Rows in Excel:

    Q.33. How to Remove Empty Rows in Excel?
    Remove Rows Conditionally
    This command allows to remove rows on specific conditions. It consists of many predefined conditions to help clean and Organize Data.
    Excel Utilities
    Remove Empty Rows
    This command is used to delete all empty rows or cell entries from selected range.
    Excel Utilities

    Interactive Tour (34/39) - Remove Duplicate Rows in Excel:

    Q.34. How to Remove Duplicate Rows in Excel?
    Remove Duplicate Rows keep First
    This command is used to delete all duplicates but keep first entry from selected range.

    Excel Utilities

    Interactive Tour (35/39) - Remove Empty Column in Excel:

    Q.25. How to Remove Empty Column in Excel?
    This command allows to remove all empty column from selected range.

    Excel Utilities

    Interactive Tour (36/39) - Convert Columnar Data into Tabular Form in Excel:

    Q.36. How to Convert Columnar Data into Tabular Form in Excel?
    This command allow the user to convert columnar data into tabular Form
    Excel Utilities

    Interactive Tour (37/39) - Remove all Empty Sheets in Excell:

    Q.37. How to Remove all Empty Sheets in Excel?
    Sheets Utilities
    There are many command to use in this utilities. you can see this in image given below select option from dropdown list. Remove all Empty Sheets
    This command is used to remove all empty sheets from active workbook.

    Excel Utilities

    Workbook Utilities
    There are many command to use in this utilities. you can see this in image given below select option from dropdown list.

    Remove all Empty Sheets from workbooks
    This command is used to remove all empty sheets from selected workbooks which are currently opened in excel.
    Excel Utilities

    Interactive Tour (38/39) - Attach Sheet to Outlook in Excel:

    Q.38. How to Attach Sheet to Outlook in Excel?
    With this option you can attach your active excel sheet configered to mail Id. If you select the given check box then the active sheet should be converted into PDF.
    Excel Utilities

    Interactive Tour (39/15) - Attach Workbook to Outlook in Excel:

    Q.39. How to Attach Workbook to Outlook in Excel?
    With this option you can attach your selected workbooks which are currently opened in excel configered to mail Id. If you select the given check box then the active workbook should be converted into PDF.
    Excel Utilities

    X discount