Replace Paragraph Marks in Excel Data Merged into Word
Question details
Replace paragraph marks created from multiline Excel cells during a Word mail merge with manual line breaks.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel cell containing multiple lines is merged into letters in Word.
- Observed behavior
- The merged lines end with paragraph marks, which can produce unwanted gaps between lines.
Finish the merge to a Word document, then turn on Home > Show/Hide ¶ to inspect the breaks. Identify which paragraph marks belong to the merged cell and which separate the rest of each letter.
Replace Merged Cell Paragraph Marks with Manual Line Breaks
Use Find and Replace on the merged output when the breaks between lines need to be manual line breaks.
In the merged Word document, select the text from a multiline Excel cell, including the paragraph marks between its lines.
Press Ctrl+H or choose Home > Replace. Enter ^p in Find what and ^l in Replace with; the second code uses a lowercase L.
Choose Replace All for the selected text. If Word asks whether to continue searching the rest of the document, choose No.
With Home > Show/Hide ¶ enabled, confirm that the selected lines now have manual line breaks and that the surrounding letter paragraphs remain intact.

Set Paragraph Spacing to Zero
Use this option when the paragraph marks can remain and the gaps are caused by paragraph spacing.
Adjust Merged Text Breaks in WPS Writer
Open the merged document in WPS Writer and use Find and Replace to change paragraph marks in the affected text to manual line breaks.
- 1. Open the document: Open the merged Word document in WPS Writer.
- 2. Select the affected text: Select the merged cell text whose internal paragraph marks need to change.
- 3. Open Find and Replace: Press Ctrl+H, enter ^p in Find what and ^l in Replace with, then choose Replace All for the selected text.
- 4. Inspect the result: Review the selected lines and surrounding paragraphs to confirm that the intended breaks and letter formatting remain.

Frequently Asked Questions
What is the difference between ^p and ^l in Word?
In Word Find and Replace, ^p represents a paragraph mark and ^l represents a manual line break. The latter uses a lowercase L.
Can I replace every paragraph mark in all 800 merged letters?
Only do a document-wide replacement if every paragraph mark should become a manual line break. Otherwise, it will also change the paragraph structure of the letters. Select the affected merged text and decline any prompt to continue through the rest of the document.
Why are there still gaps after I set paragraph spacing to zero?
Zero spacing leaves the paragraph marks in place and may not remove every visible gap. Select the affected merged text and use Home > Replace to change ^p to ^l, then inspect the result.
How can I see which breaks Word inserted?
Choose Home > Show/Hide ¶ in Word to display paragraph marks and other formatting symbols in the merged document.




