Data Import & Export

How to Stop Excel from Adding Trailing Spaces When Copying from Word

Phi Hung Vo Oct 9, 2026 868 views

Question details

The user needs to prevent extra trailing spaces from being automatically added to text values when copying tabular data from Microsoft Word to Excel.

How to Fix Excel Adding Trailing Spaces When Copying from Word

Product: Microsoft Excel
Device & OS: not provided
Scenario: Copying and pasting a table or specific text values from a Word document into an Excel spreadsheet.
Observed behavior: Unexpected trailing spaces appear at the end of the pasted text in Excel cells, which can disrupt data formatting and formula calculations.

Before you start

Ensure you have both the source Word document and the destination Excel spreadsheet open. If you plan to clean existing data with formulas, it is recommended to save a backup of your Excel file first.

Solution 1Recommended

Disable Smart Cut and Paste in Word

Disabling Word's automatic spacing adjustments during copy-paste operations is the most direct way to prevent unwanted spaces from being transferred to Excel.

Microsoft Word includes a 'Smart Cut and Paste' feature designed to automatically adjust spacing when moving text around a document. While helpful in Word, this feature often appends an extra space when pasting data into Excel cells.

Open Word Options

In your Microsoft Word application, click on the 'File' tab in the top left corner and select 'Options' at the bottom of the menu.

Navigate to Advanced Settings

In the Word Options dialog box, click on 'Advanced' in the left-hand navigation pane.

Turn off Smart Cut and Paste

Scroll down to the 'Cut, copy, and paste' section. Uncheck the box labeled 'Use smart cut and paste'.

Apply and Retry

Click 'OK' to save your changes. Return to your Word document, copy the table again, and paste it into Excel to confirm the trailing spaces are gone.

Solution 2

Clean Existing Data Using the TRIM Function

If you have already pasted a large amount of data into Excel and it contains trailing spaces, use the TRIM function to quickly clean the text.

Solution 3

Remove Hidden Nonbreaking Spaces

If the TRIM function fails to remove the space, the data likely contains nonbreaking spaces, which require a specific Find and Replace operation.

Transfer Data Seamlessly with WPS Office

Avoid frustrating formatting quirks by using WPS Office. The seamless integration between WPS Writer and WPS Spreadsheet ensures that tables and text data are copied precisely as intended, without injecting unexpected trailing spaces.

1. Open your Document in WPS Writer: Launch WPS Office, open your text document, and highlight the table or data you wish to copy.
2. Copy the Data: Right-click the highlighted data and select 'Copy', or press Ctrl+C.
3. Paste into WPS Spreadsheet: Open a new or existing WPS Spreadsheet. Right-click the destination cell, select 'Paste Special', and choose 'Unformatted text' to ensure perfectly clean data.

Highly compatible with Microsoft .docx and .xlsx formatsClean data transfer between document and spreadsheet interfacesMultiple paste options including 'Paste as Unformatted Text'Free, lightweight, and fast installation process

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word's Smart Cut and Paste add spaces in the first place?

Smart Cut and Paste is designed to ensure proper spacing between words and sentences when moving paragraphs within a text document. When you copy data from a Word table to a grid-based spreadsheet like Excel, Word still attempts to append a space to separate the text from potential adjacent words, resulting in an unwanted trailing space.

Why did the Excel TRIM function fail to remove my trailing spaces?

The standard TRIM function only removes regular space characters (ASCII value 32). If the space at the end of your text is a nonbreaking space (ASCII value 160) commonly generated in Word or copied from websites, TRIM will ignore it. You must use Find and Replace (Alt+0160) or the SUBSTITUTE function to remove it.

Can I permanently disable Smart Cut and Paste for all Word documents?

Yes. Once you uncheck the 'Use smart cut and paste' option in Word's Advanced Options menu and click OK, the setting becomes the new default for the application and applies to all future documents you open on that computer.

Is there a way to copy from Word to Excel without changing Word settings?

Yes. Instead of using standard Paste (Ctrl+V) in Excel, you can right-click the destination cell, choose 'Paste Special', and select 'Text'. This forces Excel to drop complex formatting, which often bypasses the smart spacing rules.

Excel & Data Problems