SpreadsheetShoppe

  • Home
  • Downloads
    • Accounting Tools
    • Add-Ins
    • Business Tools
    • Calendars & Timelines
    • Graphs & Charts Templates
    • Lists Templates
    • Personal Finance
    • Project Management
    • Shortcut Keys
    • Stock Options
  • Useful Resources
  • Feedback/Upload
  • Blog

Remove Unnecessary Spaces


Picture
Before spaces are removed
Picture
After spaces are removed
trim.xlam
File Size: 13 kb
File Type: xlam
Download File

+1 This Page
Cost: Free
System Requirements: Microsoft Excel® 2003 or later
User Agreement: Read it Here
Creator: SpreadsheetShoppe.com
Description: This add-in removes spaces within individual cells in Excel.  If you deal with data that often times needs to be cleaned up this add-in will save you alot of time.  Only spaces at the beginning and end of cells will be removed.  All other characters will remain as will spaces between letters and/or numbers. 

Note, if this add-in is used with formulas, the formulas will be replaced by the result (i.e., =2+2 will be replaced with 4).  

Read how to install add-ins for 2003 or 2007/2010.

There is not a shortcut key associated with this add-in; read how to add it to your quick access bar.
blog comments powered by Disqus

Other Useful Tools


Picture
Picture

Calendar 

Accounting Tools

Picture
Picture

Speedo Charts

Personal Finance


Question or comments?  Reach us Here



Microsoft® and Microsoft Excel® and Microsoft Word® are registered trademarks of Microsoft Corporation. SpreadsheetShoppe.com is not associated with Microsoft.