logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Clean data and formatting...

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Format  ›  16. 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

    Format  ›  16 Clean data and formatting...
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Format  ›  16 Clean data and formatting...
    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


  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    Empowering Excel Users Worldwide for 25 Years