Tip: Easily strip leading zeros from your numbers

Strip leading zeros

Save 5 minutes a day by using ASAP Utilities to quickly strip the leading zeros from your numbers. Quickly remove the leading zeros from numbers Some programs export numbers with leading zeros. You quickly fix these numbers with: ASAP Utilities » Numbers & Dates » Change not recognized numbers (text?) to numbers Do you recognize any of these situations? I have ...

Tip: Quickly extend your selection down to the end without scrolling

Save 5 minutes a day by using ASAP Utilities to quickly extend your selection all the way down to the end of your data. "Easily select all the way down without the mouse/scrolling" The downside of Excel's shortcut Control+Shift+Down Arrow, is that it extends your selection down till the first empty cell that is found. However, an ...

Tip: Insert a border or blank row after repeating cell values in a column

Insert a blank row at every change in value in a given column

Save 5 minutes a day by using ASAP Utilities to quickly insert borders or empty rows between repeated values. "Quickly recognize groups of data" Groups of repeated values are easier recognizable if they are separated by an empty row, border line or color. You can quickly do that with the following tool: ASAP Utilities » Columns & Rows » Detect ...

Tip: Select cells automatically based on their contents, formatting, etc.

Select cells based on their value, lenght, etc.

Save 5 minutes a day by using the "Select » Select cells based on content, formatting and more..." tool: Quickly select certain cells automatically? You can have cells selected automatically for you, with the following tool: ASAP Utilities » Select » Select cells based on content, formatting and more... Especially when you need to select more than a dozen ...

Tip: Get rid of unwanted spaces in your data

Delete leading, trailing and excessive spaces

Save 5 minutes a day by using the "Text » Delete leading, trailing and excessive spaces" data cleanup tool: Quickly remove all unnecessary spaces With: ASAP Utilities » Text » Delete leading, trailing and excessive spaces Remove all spaces from the beginning and end of your data and replace duplicated spaces between words with a single space. Do you ...

Tip: Quickly perform a calculation on all selected cells at once

Apply formula/calculation to selected cells

Save 5 minutes a day by using the "Apply formula/calculation to selected cells..." tool: Quickly apply a calculation to all selected cells at once With: ASAP Utilities » Formulas » Apply formula/calculation to selected cells... With this utility you can quickly perform a calculation on all selected cells at once. There are many situation in which we think this ...