Pricing Free
Remove leading, trailing and excess spaces from your tables with Trim Spaces
The Trim Spaces app for Excel from AbleBits.com helps you delete all extra spaces in your tables with just a single click.
Extra spaces can creep in when you get data from different sources. These extra spaces might prevent you from sorting, processing data, making calculations or creating charts. You can clear the cells of leading, trailing, or other excess spaces by following a few simple steps.
Just select the range in your worksheet, start the app and pick the options that suit you:
· Trim Leading/trailing spaces will remove all excess spaces before and after the cell values
· Trim Spaces between words to one will delete extra spaces within cells
· Trim ' ' will help you get rid of ' ' that are common with data from web pages
Once you click Trim, you get your spaces-free table!
Please note that any formulas in your range will be overwritten with values. You can cancel the process to keep them, or continue and have the values inserted.
Trim spaces app is a helpful tool for any active Excel user.
App capabilities
When this app is used, it
- Can read and make changes to your document
- Can send data over the Internet
At a glance
Other apps from Tyrant Ventures LLC
Random GeneratorTyrant Ventures LLC
ExcelGenerate random numbers, dates, and Booleans in Excel 2013 using Random Generator app by Ablebits
ExcelApplicable to:Excel
ExcelNaN out of 5
Change CaseTyrant Ventures LLCExcelSwitch words to upper or lower case, capitalize cells in Excel with Change Case app by Ablebits
ExcelApplicable to:Excel
ExcelNaN out of 5
Merge CellsTyrant Ventures LLCExcelMerge values in rows, columns, or the entire range using Merge Cells app for Excel 2013 by Ablebits
ExcelApplicable to:Excel
ExcelNaN out of 5
Remove Unwanted CharactersTyrant Ventures LLCExcelDelete non-printing and special symbols from Excel with Remove Unwanted Characters app by Ablebits
ExcelApplicable to:Excel
ExcelNaN out of 5
Random SorterTyrant Ventures LLCExcelShuffle entire rows, columns, or cells in a range using Random Sorter app for Excel 2013 by Ablebits
ExcelApplicable to:Excel
ExcelNaN out of 5
By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's terms of use and privacy policy and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of AppSource is governed by separate terms and privacy.