Formatting Issues

How to Remove Extra Spaces When Copying Excel Tables to Word

Adam Davis Oct 10, 2026 872 views

Question details

The user needs to remove unwanted extra spaces that appear inside cells after pasting a table from Excel into a Word document.

How to Remove Extra Spaces When Copying an Excel Table to Word

Product: Excel, Word
Device & OS: not provided
Scenario: Copying and pasting tabular data from a spreadsheet into a text document.
Observed behavior: The table looks correct in Excel without spacing issues, but extra spaces appear inside the cells once pasted into Word due to hidden formatting or trailing space characters.

Before you start

Before proceeding, click inside the affected cells in Excel to verify if actual space characters exist at the end of your text, or if the spaces are caused by specific cell formatting such as the Accounting number format.

Solution 1Recommended

Clean Up Source Data in Excel Using the TRIM Function

Use this method to automatically remove hidden trailing and leading spaces from your Excel data before pasting it into Word.

The most reliable way to prevent unwanted spaces from carrying over to Word is to clean the text data directly in your spreadsheet using the TRIM function.

Add a helper column

Insert a blank column right next to the data column that contains the extra spaces.

Apply the TRIM formula

In the first cell of the helper column, type the formula =TRIM(A1) (assuming A1 is the cell with the original text) and press Enter.

Fill the formula down

Click the small square at the bottom-right corner of the cell and drag it down to apply the formula to the rest of the column.

Overwrite original data as values

Select the newly cleaned column, press Ctrl+C to copy, then right-click the original column and select Paste as Values to lock in the text.

Delete helper column and paste to Word

Delete the temporary helper column, copy your now-clean table, and paste it into your Word document.

Data Integrity: Using the TRIM function only removes extra spaces at the beginning, end, and multiple spaces between words, keeping a single natural space between words intact.

Solution 2

Remove Extra Spaces Using Word's Find and Replace Feature

If the table is already pasted into Word and you do not want to alter the Excel file, use Word's Find and Replace tool to quickly eliminate double spaces.

Solution 3

Clear Source Formatting After Pasting in Word

Sometimes, extra spacing is just a visual artifact caused by imported Excel formatting rules. Clearing the source formatting can instantly resolve this layout issue.

Seamless Cross-App Integration

Easily Copy and Paste Tables with WPS Office

WPS Office provides seamless integration between Spreadsheets and Writer, ensuring that cell formatting, alignment, and spacing are perfectly preserved when copying tables without unwanted extra spacing artifacts.

1. Copy from WPS Spreadsheet: Open your spreadsheet file in WPS Spreadsheet, highlight the table range, right-click, and select Copy.
2. Paste into WPS Writer: Switch to your document in WPS Writer, right-click the destination area, and hover over Paste Options.
3. Choose the optimal paste format: Select 'Keep Source Formatting' to maintain the exact spreadsheet look without phantom spaces, or 'Keep Text Only' if you just want the raw data.

Seamless copy-pasting between Spreadsheets and Writer without formatting glitchesBuilt-in TRIM and text-cleaning functions to format spreadsheet data instantlyFully compatible with Microsoft Excel (.xlsx) and Word (.docx) formatsLightweight, easy to use, and completely free to download

microsoft office alternative - wps office

Frequently Asked Questions

Why do extra spaces appear only after I paste the Excel table into Word?

This usually happens because Excel hides trailing spaces visually based on column width, or due to certain cell formatting (like the Accounting format which pushes currency symbols and numbers apart). When pasted into Word, these hidden characters or spatial rules are translated into visible space characters.

Can I paste an Excel table into Word as an image to avoid formatting issues completely?

Yes. Copy the table in Excel, switch to Word, right-click the destination area, and choose 'Picture' under Paste Options. This completely prevents text spacing changes and locks the layout, but keep in mind you will no longer be able to edit the table's text in Word.

Does the TRIM function remove all spaces between words?

No. The TRIM function is designed to only remove leading spaces, trailing spaces, and extra consecutive spaces between words. It safely leaves a single natural space between words intact.

Document & File Issues