How to remove trailing spaces from cells in Microsoft Excel?

Sometime we may add unwanted spaces in Excel cells, which are not easy to find out but affect sorting, calculating, or others. This article will introduce several methods to remove trailing spaces after text strings of cells in Microsoft Excel.

Remove trailing spaces from cells in Excel with VBA

Remove trailing spaces from cells in Excel with Kutools for Excel

Recommended Productivity Tools

Office Tab: Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Kutools for Excel: 200 new features for Excel, make Excel much easy and powerful, increase productivity immediately.

---

Remove trailing spaces from cells in Excel with VBA

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

---

Using the Trim function is easy to remove the trailing space in one cell, but time-consuming to remove trailing spaces in many cells. Here provides a macro to remove all trailing spaces of all cells in a selection.
Step 1: Select the range in which you want to remove trailing spaces from cells.
Step 2: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 3: Click Insert > Module, and paste the following macro in the Module Window.

Sub NoSpaces()
Dim c As Range
For Each c In Selection.Cells
c = Trim(c)
Next
End Sub

Step 4: Press the F5 key to run this macro. And all of the trailing spaces of the selection will be removed.

---

Remove trailing spaces from cells in Excel with Kutools for Excel

Maybe you are not familiar with Microsoft Excel's Macros, and need time to study it. Please do not worry about it. The second method is provided by a third-party add-in, Kutools for Excel. Its Remove Spaces tool can help you remove trailing spaces from cells quickly.
Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.
Step 1: Select the range in which you want to remove all trailing spaces from cells.
Step 2: Click the Kutools > Text Tools > Remove Spaces. See screenshot:

Step 3: In Remove Spaces dialog box, check the Trailing Spaces option in Spaces Type section. See screenshot:

Step 4: Click OK or Apply. And all the trailing spaces after the text string have been removed. See screenshot:
Kutools for Excel's Remove Spaces tool makes it possible to delete all kinds of spaces from strings in cells, including all extra spaces, leading spaces, trailing spaces, or all spaces. Click to know more...

The Save As dialog box appears two times when you try to save a file in Word 2010 or in Word 2007

SYMPTOMS

When you click Save or Save As to save a file in Microsoft Word 2010 or in Microsoft Word 2007, the Save As dialog box appears two times.

CAUSE

This problem occurs because the Normal.dotm template is corrupted.

RESOLUTION

To resolve this problem, create a new Normal.dotm file by changing the name of the old file. To do this, follow these steps: 

1. Start Windows Explorer, type %appdata%\Microsoft\Templates in the address bar, and then press Enter.
   
   
2. Right-click Normal.dotm, and then click Rename.
   
   
   
3. Change the file name to Normal.old.dotm.
   
   
   
4.  Restart Word. A Normal.dotm template is automatically generated.
   
   
   
5. Try to save a file to check whether the problem is resolved.

source: https://support.microsoft.com/en-in/kb/2637570