CNET Editors' review
When you import data in Excel, you also import any blank spaces that come with it, which isn't a problem in day-to-day use. If you try to process the data, though, extra spaces can lead to problems, such as masking duplicate files from tools designed to find and remove them. Trim Spaces for Excel from Add-in Express is a free Excel add-in that can locate and remove leading and trailing spaces in cells in Excel documents.
We installed Trim Spaces in Excel 2010 and opened a spreadsheet. The Trim Spaces Help file opened automatically, while an AbleBits.com tab appeared among the file menus on the Quick Access Toolbar. The tool is very easy to use. We selected a range of cells and clicked the Trim Spaces button on the Ribbon. We clicked Run on the pop-up that appeared, and a progress bar and counters for values processed and values trimmed showed the results, 0 out of 24 values trimmed, meaning there were no hidden leading or trailing spaces. It took us a while to find an Excel document with hidden spaces, but Trim Spaces made short work of them when we did. Most of the time, Trim Spaces probably won't find spaces in your Excel sheets. That's not a problem, though, since making sure there are no spaces is part of this program's job.
Trim Spaces for Excel supports Excel 2000 to 2010 32-bit and Windows XP to 7, including 64-bit editions like ours. It works fast and does what would seem to be a unique and valuable job. It's free, too, so we'd consider it an essential add-on for frequent Excel-ers.
Publisher's Description
From Add-in Express:
The Trim Spaces for Excel add-in helps you remove leading and trailing spaces in selected cells. Just select a cells, click the Run button of the add-in and no excess spaces are left in your worksheet.
More Popular Office Suites downloads
- Microsoft Office Word 2010
29,568 downloads
- OpenOffice.org
14,779 downloads
- Microsoft Office 2010
12,333 downloads
- Kingsoft Office 2012
7,219 downloads
- PowerPoint Viewer 2007
6,473 downloads
-
All versions:
5.0 starsout of 2 votes
-
Current version:
5.0 starsout of 1 votes
-
My rating:
Write review
Results 1-1 of 1
-
"Works exceptionally well."
Version: Trim Spaces for Microsoft Excel 1.3.5.57
Pros
Allows more precise string extraction when mining sentences and parts of words using Excel functions and database commands.
Cons
No complaints.
Add Your Review
Submit your reply
E-mail this review
Report offensive content
See more CNET content tagged:
Previous Versions:
