The ASAP Utilities menu in Excel (English)
Clean Up Data and Formatting...
ASAP Utilities › Text › 12. Clean Up Data and Formatting...This tool helps you quickly clean up data and formatting issues in your selected range. It's useful when working with pasted or imported data, exports from other systems, or spreadsheets with inconsistent formatting and values.
Instead of manually fixing everything, you can apply multiple cleanup actions in one go, saving time and making your data easier to work with. You can choose to apply any combination of the following actions:
Screenshots
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
- Click ASAP Utilities › Text › 12. Clean Up Data and Formatting...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
Clean up Excel data, Remove extra spaces, Clean formatting in Excel, Fix numbers stored as text, Trim spaces tool, Remove unwanted formatting, Remove hyperlinks, Unmerge cells, Reset Excel formatting, Clean copied data, Prepare data for analysis, Remove fill color, Fix pasted data, Clean data from website, Tidy up spreadsheet, Remove cell borders, Remove font color, Standardize cell formatting, Autofit columns and rows, Bulk clean data, Textnumbers, Convert imported values, Clean dataset, Clean information that is copied from websites
Clean up Excel data, Remove extra spaces, Clean formatting in Excel, Fix numbers stored as text, Trim spaces tool, Remove unwanted formatting, Remove hyperlinks, Unmerge cells, Reset Excel formatting, Clean copied data, Prepare data for analysis, Remove fill color, Fix pasted data, Clean data from website, Tidy up spreadsheet, Remove cell borders, Remove font color, Standardize cell formatting, Autofit columns and rows, Bulk clean data, Textnumbers, Convert imported values, Clean dataset, Clean information that is copied from websites
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Remove Leading, Trailing, and Extra Spaces Between Words |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.