Tip: An easier way to fix the numbers that Excel doesn't recognize

ASAP Utilities » Numbers & Dates » Convert unrecognized numbers (text?) to numbersSave 5 minutes a day by using ASAP Utilities to quickly fix the numbers that Excel may not recognize. "Easily make Excel recognize the numbers in your selection" Sometimes Excel fails to recognize numbers properly, which causes unexpected results when you sort, filter, or use formulas. For example, when you import a file that was created in another ...

Tip: Quickly remove spaces from the beginning and end of your data

Delete leading and trailing spacesSave 5 minutes a day by using ASAP Utilities to quickly remove leading and trailing spaces from your data. "Easily trim all leading and trailing spaces" Sometimes your data contains leading or trailing spaces. Someone may have accidentally added extra space characters, or imported text data from external sources may contain extra spaces. Leading and/or trailing spaces can ...