Trim those cells in Excel

As I was working on a spreadsheet today, I realized that I had several cells with extra spaces at the end. I knew that there was a Trim function in Excel, but I didn't want to go through the hassle of determining the syntax and use, so instead I went to Google. THe third link I followed, I found Trim Spaces for Microsoft Excel.

Trim Spaces for Microsoft Excel is easy to install and easy to use, and works on many version of Excel. Here are the steps I followed:
  1. Downloaded
  2. Opened the zip file
  3. Opened the Readme.txt, which contained instructions
  4. Closed Excel
  5. Ran setup.exe
  6. Closed the Zip file
  7. Opened my Excel file in Excel
  8. Highlighted the cells to trim
  9. Clicked the Trim spaces button
  10. Saved my Excel file

It doesn't get any easier! You can even use a silent installation -- great for IT groups who want to deploy. Trim Spaces for Microsoft Excel is freeware, "The add-in is free for private and commercial use." That's a bargain, too.

Here's are the supported platforms:
Trim Spaces for Excel works with the following Microsoft Excel versions:
- Microsoft Excel 2007.
- Microsoft Excel 2003.
- Microsoft Excel 2002 (XP).
- Microsoft Excel 2000.

Trim Spaces for Excel works with the following Microsoft Windows versions:
- Microsoft Windows Vista
- Microsoft Windows 2003
- Microsoft Windows XP
- Microsoft Windows 2000
- Microsoft Windows ME
It appears had many other Office plug-ins and add-ons worthy of further investigation. Perhaps I'll find another one worth sharing.


Popular posts from this blog

Digital Signatures in PDF Do Not Print

Referencing the value of a cell, not its formula

CorelDRAW X4 Crash on Startup