How to Remove Paragraph Marks Before Pasting a Word Table into Excel
Question details
The user needs to prevent paragraph marks inside a Word table's cells from splitting into unwanted extra rows when the table is pasted into an Excel spreadsheet.

- Product
- Word, Excel
- Device & OS
- not provided
- Scenario
- Copying a formatted table containing multi-line cells from Microsoft Word and pasting it into Microsoft Excel.
- Observed behavior
- Paragraph marks (carriage returns) in the Word table trigger new rows in Excel, disrupting the intended row-by-row data layout.
Before proceeding, it is highly recommended to save a copy of your Word document, as performing bulk replacements of paragraph marks will alter the original text formatting within your table.
Use Find and Replace with a Temporary Marker
Use the Find and Replace feature in both Word and Excel to substitute paragraph marks with temporary characters, preserving your table structure during the paste.
Because Excel interprets standard paragraph marks as a command to move to the next row, you must replace them with a placeholder in Word before copying. Once the table is safely in Excel, you can convert that placeholder back into an in-cell line break.
Select the entire table in Word, then press Ctrl+H to open the Find and Replace dialog. Type ^p in the 'Find what' field, and enter a unique temporary marker like @@@ in the 'Replace with' field. Click 'Replace All'.
Select the modified table in Word, press Ctrl+C to copy it, switch to your Excel spreadsheet, and press Ctrl+V to paste.
In Excel, select the pasted table data and press Ctrl+H. Type @@@ in the 'Find what' field. Click inside the 'Replace with' field and press Ctrl+J to insert a line break.
Click 'Replace All' to swap the markers for actual line breaks. Ensure 'Wrap Text' is enabled on your Excel toolbar so the multi-line text displays properly inside the cells.

Easily Copy and Paste Tables Between Writer and Spreadsheet
WPS Office provides high compatibility and seamless data transfer between its Writer and Spreadsheet applications. You can use the exact same Find and Replace tricks natively and enjoy a unified, lightweight office suite for free.
- 1. Prepare the table in WPS Writer: Open your document in WPS Writer, select the table, and press Ctrl+H. Use ^p to find paragraph marks and replace them with a marker like @@@.
- 2. Paste into WPS Spreadsheet: Copy the table, click the '+' icon at the top to open a new tab in WPS Spreadsheet, and paste the data.
- 3. Format the cells: Press Ctrl+H in WPS Spreadsheet, find @@@, and replace it by pressing Ctrl+J to restore your in-cell line breaks.

Frequently Asked Questions
Why do paragraph marks in Word create new rows in Excel?
When you paste data into Excel, it interprets standard paragraph marks (carriage returns) as a command to move to the next row. This splits a single Word cell containing multiple paragraphs across several separate rows in your spreadsheet.
What does ^p mean in the Word Find and Replace dialog?
^p is the special code Microsoft Word uses to represent a paragraph mark. Typing this into the 'Find what' field allows the program to locate and replace all hard line breaks at once.
How do I type Ctrl+J in Excel's replace box, and what does it do?
Simply click inside the 'Replace with' box and press the Ctrl and J keys simultaneously. You won't see a standard character, but you might notice a tiny blinking dot. This inserts an ASCII line feed, which Excel reads as an in-cell line break rather than a new row.
Can I remove the paragraph marks completely instead of replacing them?
Yes. If you do not need line breaks in your Excel cells, you can leave the 'Replace with' box completely empty in Word. This will merge the text into one continuous line when pasted into Excel.




