Formatting Issues

Replace Paragraph Marks in Excel Data Merged into Word

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 869 views

Question details

Replace paragraph marks created from multiline Excel cells during a Word mail merge with manual line breaks.

Replace Paragraph Marks in Excel Data Merged into Word
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the merged text

In the merged Word document, select the text from a multiline Excel cell, including the paragraph marks between its lines.

2
Open Replace

Press Ctrl+H or choose Home > Replace. Enter ^p in Find what and ^l in Replace with; the second code uses a lowercase L.

3
Replace the breaks

Choose Replace All for the selected text. If Word asks whether to continue searching the rest of the document, choose No.

4
Check the result

With Home > Show/Hide ¶ enabled, confirm that the selected lines now have manual line breaks and that the surrounding letter paragraphs remain intact.

Replace Merged Cell Paragraph Marks with Manual Line Breaks
Avoid replacing every paragraph mark: A document-wide replacement also changes the paragraph marks that structure the letters. For a large merge, this selective method may need to be repeated unless all paragraph marks in the replacement scope should become line breaks.
Work with merged text in WPS Writer

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. 1. Open the document: Open the merged Word document in WPS Writer.
  2. 2. Select the affected text: Select the merged cell text whose internal paragraph marks need to change.
  3. 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. 4. Inspect the result: Review the selected lines and surrounding paragraphs to confirm that the intended breaks and letter formatting remain.
Replace unwanted breaks in selected merged textCompatible with Microsoft Word DOC and DOCX filesFamiliar editing tools for reviewing letter formattingFree office suite for working with documents and spreadsheets
microsoft office alternative - wps office

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.