logo ASAP Utilities

You can do this too

Download “The one essential add-in for all Excel users.'”
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

Language: English Nederlands (Dutch) Deutsch (German) Espa˝ol (Spanish) Franšais (French)

Web » Clean data and formatting...

This utility helps you to optimize and clean information that you have copied into Excel.

You can choose the following edits:
  • remove all hyperlinks
  • trim spaces (removes leading and trailing spaces)
  • remove all cell colors
  • remove all font colors
  • remove all borders
  • unmerge cells
  • apply standard font
  • apply standard font size
  • no wrap-text
  • fix (text)numbers
  • autofit columns
  • autofit rows
  • remove all objects/images from your worksheet

    Your last used settings will be remembered.

    Screenshots

    Web » Clean data and formatting...

    Starting this utility

    In the Excel menu choose: ASAP Utilities » Web » Clean data and formatting...

    « Return to the list of “Web” tools.
    « Previous
    Show flowchart toolbars
     
     Next »
    Remove all HTML tags in the selected cells...
    Excel 2010 with ASAP Utilities in the menu
    Download ASAP Utitilities
    Additional keywords for this tool:
    Colour, strip html tags, colours, double space, extra spaces, website data, clean up, table, textnumbers, remove unwanted space from cell, clean it up before you can analyze the data, convert imported values, clean dataset, clean information that is copied from websites

    Follow ASAP Utilities on Facebook



  • Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
    ę 1999-2014 - - - - The Netherlands EnglishDutch - NederlandsGerman - DeutschSpanish - Espa˝olFranšais (French)

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook