https://store-images.s-microsoft.com/image/apps.31864.c12dced2-c18a-4c09-9789-0479309e8658.62538f15-081a-4c5e-a7b1-28aa2ef6129b.4c6c8059-7380-4a1d-8a55-af472ede4a21.png

Ablebits.com Trim Spaces for Excel

Tyrant Ventures LLC

AppSource 評分(11 AppSource 評分)

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.

增益集功能

使用此增益集時,其
  • 可以讀取及變更您的文件
  • 可以在網際網路上傳送資料

概覽

https://store-images.s-microsoft.com/image/apps.40853.c12dced2-c18a-4c09-9789-0479309e8658.62538f15-081a-4c5e-a7b1-28aa2ef6129b.3e2d1884-5360-4abc-af0c-5ae2e5012c23.png
https://store-images.s-microsoft.com/image/apps.3002.c12dced2-c18a-4c09-9789-0479309e8658.62538f15-081a-4c5e-a7b1-28aa2ef6129b.47405f72-6577-4087-bdba-41d2d7ce0590.png

來自 Tyrant Ventures LLC 的其他應用程式

評分(6 評分)
Merge CellsTyrant Ventures LLC
+1
Merge values in rows, columns, or the entire range using Merge Cells app for Excel 2013 by Ablebits
NaN out of 5
評分(7 評分)
Random GeneratorTyrant Ventures LLC
+1
Generate random numbers, dates, and Booleans in Excel 2013 using Random Generator app by Ablebits
NaN out of 5
評分(10 評分)
Change CaseTyrant Ventures LLC
+1
Switch words to upper or lower case, capitalize cells in Excel with