• ASAP Utilities
  • Download
  • Contact Us
ASAP Utilities Icon

ASAP Utilities Blog

“Do more and save time in Excel with these popular tools”

  • Home
  • Practical Tricks to Save Hours in Excel
  • Download
ASAP Utilities how to with ASAP Utilities

How to: Quickly find the utility you need

Feb 10, 2009 Bastien 0 Comment
Run and find a utilityWith the new version 4.3 of ASAP Utilities it will be easier to find the utility you need with the tool "Find and run a utility...". We have improved this already existing utility. The results are presented better and you can now immediately start/run the utility from the search results. If you click on the ...
ASAP Utilities how to with ASAP Utilities

How to: Remove all spaces, dashes and other garbage from numbers

Feb 10, 2009 Bastien 0 Comment
I got a question from Ryan: I have a bunch of excel cells and I need them all to have no spaces and no dashes so the first one would be: 185444001 and so on. How can I use ASAP Utilities to remove all spaces and dashes? You can do this very quick with the following utility: ASAP ...
ASAP Utilities how to with ASAP Utilities

How to: Delete blank lines in a cell with multiple lines of text?

Feb 10, 2009 Bastien 1 Comment
Example of cells with linebreaksI'm sure you know you can enter a new line/line break by pressing Alt+Enter. But working with these newline characters can sometimes be a bit difficult, for example if you want to remove or replace them. If you have cells with multiple empty lines it can be difficult to quickly replace them all. Method 1: Do it ...
ASAP Utilities how to with ASAP Utilities

How to: Remove all blank rows at once

Feb 4, 2009 Bastien 0 Comment

If you have a lot of data it can be difficult to identify and remove the empty rows. There is no way in standard Excel to quickly remove all empty rows* so it can be a time-consuming job. You need to use a macro for that. Empty rows in your table can cause problems with sorting ...

ASAP Utilities Reviews

Trustpilot

Recent posts

  • The importance of Microsoft Office Update | Fix random crashes and performance issues
  • Tip: Easily move and resize your range selection(s) in Excel (Video Tutorial)
  • Small update to website and blog: responsive/mobile friendly
  • Tip: Quickly save just your selection or sheet as a new file
  • Tip: Quickly clean up your data in Excel

Categories

  • ASAP Utilities
  • Functions
  • General
  • How to
  • how to with ASAP Utilities
  • save 5 more minutes a day

Excel blogs

  • Headlines from the best Excel weblogs

Excel sites

  • AJP Excel Information
  • Application Professionals
  • AutomateExcel
  • Contextures
  • David McRitchie
  • ExcelUser.com
  • JKP Ads Excel articles
  • Jon Peltier (charts)
  • Office Automation
  • OzGrid
  • Vertex42

Excel Discussions

  • Microsoft Office Discussion Groups
  • MrExcel forum
Copyright © 1999-2025 | ASAP Utilities for Excel | Powered by WordPress | ConsultStreet theme by ThemeArile