Microsoft Excel Add-In To Trim Spaces - gHacks Tech News

Microsoft Excel Add-In To Trim Spaces

microsoft excelSpaces are usually not a problem in Microsoft Excel. They usually occur when importing data from another source and are either located at the beginning or end of the data. These spaces can become a huge problem for users who have to process the data further as spaces can pollute the results.

The Trim Spaces add-in for Microsoft Excel has been designed to clean spaces from data that is located in an Microsoft Excel file. To be more precise: The Excel add-in will remove trailing or leading spaces in the data and leave the other spaces in their places.

microsoft excel trim spaces

All it takes to remove spaces from Excel cells is to select the cells that should be processed by the add-in and to click on the run button afterwards. This will automatically process all select cells and remove leading and trailing spaces from these cells. A report is generated in the end that is listing the number of processed cells and the cells that have been trimmed.

trim spaces excel result

The Trim Spaces add-in for Microsoft Excel is compatible with the last four major released of Microsoft Excel (that is Excel 2007, Excel 2003, Excel XP (2002) and Excel 2000).

We need your help

Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.

We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats or subscription fees.

If you like our content, and would like to help, please consider making a contribution:

Comments

  1. DanTe said on September 14, 2009 at 3:29 pm
    Reply

    Thanks for this info. Currently, I just load the data into the old Lotus 1-2-3 or OpenOffice prior to loading it into Hyperion databases. Excel is a b*tch when it comes to data with spaces.

Leave a Reply

Check the box to consent to your data being stored in line with the guidelines set out in our privacy policy

Please note that your comment may not appear immediately after you post it.