Formatting Issues

How to Remove Paragraph Marks Before Pasting a Word Table into Excel

Kushani NimanthikaKushani Nimanthika Nov 11, 2026 869 views

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.

How to Remove Paragraph Marks Before Pasting a Word Table into Excel
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 you start

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.

Solution 1Recommended

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.

1
Replace paragraph marks in Word

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'.

2
Copy and paste into Excel

Select the modified table in Word, press Ctrl+C to copy it, switch to your Excel spreadsheet, and press Ctrl+V to paste.

3
Restore line breaks in Excel

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.

4
Enable Wrap Text

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.

Use Find and Replace with a Temporary Marker
Tip for Mac Users: If you are using a Mac, the shortcut Ctrl+J in Excel will not work. Instead, use Option+Command+Return in the 'Replace with' box to insert a line break.
Seamless Table Transfer with WPS Office

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. 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. 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. 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.
Seamlessly copy and paste data between document and spreadsheet interfaces.Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) file formats.Unified, tabbed workspace allowing you to open both apps in a single window.Lightweight software that uses significantly fewer system resources.
microsoft office alternative - wps office

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.