How to Remove Line Breaks in Excel, Word & Notepad
Why Does Copied Text Always Look Broken?
You copied a paragraph from a PDF, email, or webpage and pasted it into Excel. Suddenly, every sentence appears on a separate line. The original text looked perfectly normal, but the pasted version is full of unwanted line breaks.
This is a common formatting problem when working with copied text. The exact fix depends on where you’re working because Excel, Word, Notepad++, and Google Sheets handle line breaks in different ways.
In this guide, you’ll learn how to remove line breaks in Excel, Word, Notepad++, and Google Sheets using built-in features, formulas, and simple text-cleaning methods. You’ll also learn how to tell the difference between a paragraph break and a manual line break before removing anything.
Why Line Breaks Appear in the First Place
A line break is a character or formatting instruction that moves text to a new line. When text is copied between applications, those characters can sometimes come along with the text and create unwanted breaks.
Depending on the source, copied content may contain:
- Paragraph breaks created with the Enter key
- Manual line breaks created with Shift + Enter
- Newline characters such as
\nor\r\n - Tab characters and extra spaces
- Line wrapping introduced by the original document layout
PDFs are a common source of this problem because text that looks like one continuous paragraph visually may be copied with line breaks depending on how the PDF was created. Web pages and emails can also introduce unwanted spacing or newline characters.
The important thing is to identify what kind of break you’re dealing with before replacing it. Let’s start with Excel.
How to Remove Line Breaks in Excel
Learning how to remove line breaks in Excel is relatively simple once you know where Excel stores the break. You can use Find & Replace for quick cleanup or a formula when you want to keep the original data unchanged.
Method 1: Find & Replace with Ctrl + J
- Select the cell, column, or range containing the text you want to clean.
- Press Ctrl + H to open Find and Replace.
- Click inside the Find what field.
- Press Ctrl + J. This inserts a line-break character into the search field, even though it may not appear visibly.
- Click inside Replace with and type a single space.
- Click Replace All.
Excel will replace the matching line breaks with spaces. This is useful when copied text has been split into multiple lines and you want it to read as a continuous sentence or paragraph.
Method 2: Remove Line Breaks with SUBSTITUTE
If you prefer a formula, use Excel’s SUBSTITUTE function:
=SUBSTITUTE(A1,CHAR(10)," ")
Here, CHAR(10) represents a line-feed character. The formula replaces each matching line break in cell A1 with a space and returns the cleaned text in another cell.
This method is useful when you want to keep the original column untouched and create a separate cleaned version of your data.
Method 3: Remove Line Breaks from a Larger Range
If you need to clean many cells, select the relevant range before opening Find and Replace. Then use Ctrl + J in the Find what field and a space in Replace with.
Before clicking Replace All, make sure you’ve selected the intended range. This helps prevent accidental changes to unrelated data on the worksheet.
How to Keep Paragraph Separation
Simply replacing every line break with a space can remove meaningful paragraph separation. If your text contains blank lines between paragraphs, consider cleaning the text with a formula first rather than replacing everything blindly.
For example, this formula temporarily protects double line breaks before replacing individual breaks:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,CHAR(10)&CHAR(10),"♦"),CHAR(10)," "),"♦",CHAR(10)&CHAR(10))
The diamond character is used as a temporary marker, so choose a marker that does not already appear in your data. This approach can help preserve paragraph spacing while removing unwanted single line breaks.
For more Excel-specific help, Microsoft’s documentation on Find and Replace in Excel is another useful reference.
How to Remove Line Breaks in Word
Microsoft Word distinguishes between paragraph breaks and manual line breaks. Knowing which one you want to remove is important because replacing the wrong type can change the structure of your document.
The Two Common Types of Breaks in Word
- Paragraph breaks — created by pressing Enter and represented by
^pin Find and Replace. - Manual line breaks — created by pressing Shift + Enter and represented by
^l.
Remove Manual Line Breaks Without Removing Paragraphs
- Press Ctrl + H to open Find and Replace.
- In the Find what field, enter
^l. - In the Replace with field, enter a space.
- Click Replace All.
This method targets manual line breaks specifically, making it useful when text has been broken into short lines but the paragraph structure should remain intact.
Remove Paragraph Breaks
- Open Find and Replace with Ctrl + H.
- Enter
^pin Find what. - Enter a space in Replace with.
- Choose Replace All.
Be careful with this method because it targets paragraph marks. Replacing them all can merge separate paragraphs into one continuous block of text.
Use Word’s Show/Hide Formatting Marks
If you’re unsure what kind of break exists in your document, turn on the ¶ Show/Hide button in Word. You can also press Ctrl + Shift + 8.
Once formatting marks are visible, you can see paragraph marks, manual line breaks, and other hidden formatting characters before deciding what to remove.
How to Remove Line Breaks in Notepad and Notepad++
Basic Windows Notepad is designed for simple text editing and does not provide the same Find and Replace controls available in applications such as Excel, Word, or Notepad++. For larger text-cleaning tasks, Notepad++ provides more advanced search and replacement options.
Using Notepad++ to Remove Line Breaks
Notepad++ is a free, open-source text editor with advanced Find and Replace functionality.
- Open the text file in Notepad++.
- Press Ctrl + H to open Replace.
- Choose the appropriate Search Mode.
- For Windows-style line endings, you can search for
\r\nwhen using a mode that interprets these escape sequences. - Enter a space in the Replace with field.
- Click Replace All.
The exact line-ending sequence can depend on how the text file was created. Windows commonly uses a carriage return plus line feed (\r\n), while other systems may use a different line-ending convention.
What If You Only Have Basic Notepad?
For a small amount of text, manual editing may be enough. For larger blocks of copied text, however, a dedicated text-cleaning tool or a more advanced editor can save considerable time.
How to Remove Line Breaks in Google Sheets
Google Sheets can also contain line breaks inside individual cells. You can clean them with Find and Replace or with the SUBSTITUTE function.
Using Find and Replace
- Select the cells or range you want to clean.
- Open Find and replace.
- If your Sheets version supports regular expressions in Find and Replace, enable Search using regular expressions.
- Use
\nas the search pattern for a line-feed character. - Enter a space in the replacement field.
- Run the replacement on the selected data.
Using SUBSTITUTE in Google Sheets
You can also use the same basic formula approach as Excel:
=SUBSTITUTE(A1,CHAR(10)," ")
This returns a version of the cell with line-feed characters replaced by spaces while leaving the original cell unchanged.
Which Method Should You Use?
The best method depends on where your text is stored and whether you need to preserve paragraphs or other formatting.
- Excel: Use Ctrl + H with Ctrl + J for quick cleanup, or
SUBSTITUTEwhen you want a separate cleaned result. - Word: Use
^lfor manual line breaks and^pwhen you intentionally want to remove paragraph breaks. - Notepad++: Use Find and Replace when working with text files and different line-ending formats.
- Google Sheets: Use Find and Replace or
SUBSTITUTEfor line breaks inside cells. - Mixed or copied text: A browser-based line break remover can be useful when you don’t want to switch between applications or remember different shortcuts.
Need to Remove Line Breaks from Plain Text?
If your text is not specifically tied to an Excel, Word, or Google Sheets workflow, you can use our line break remover to clean copied text directly in your browser.
It’s useful for text copied from documents, emails, webpages, and other sources where unwanted line breaks make the content difficult to read. You can choose how the breaks should be handled and then copy or download the cleaned result.
This is a supporting option for general text cleanup — for spreadsheet-specific work, the Excel and Google Sheets methods above give you more control over the original data.
4 Pro Tips for Removing Unwanted Line Breaks
1. Identify the Type of Break First
Don’t immediately replace every newline you find. In Word, for example, a manual line break and a paragraph break serve different purposes. Knowing the difference helps prevent accidental formatting changes.
2. Test Replace All on a Copy
Find and Replace can modify a large amount of text at once. If the content is important, make a copy of the worksheet or document and test your replacement before applying it to the original.
3. Watch for Other Hidden Characters
Sometimes unwanted spacing is not caused by line breaks at all. Tabs, multiple spaces, non-breaking spaces, and unusual Unicode characters can also make copied text look incorrect.
4. Keep the Original Data
When cleaning imported or copied information, keep the original version until you’ve checked the result. This makes it much easier to recover if an aggressive replacement removes more formatting than expected.
Frequently Asked Questions
Why does Ctrl + J remove line breaks in Excel?
Ctrl + J inserts a line-feed character into Excel’s Find what field. This allows Find and Replace to search for line breaks that are stored inside cells. You can then replace them with a space or another character.
What is the Excel formula to remove line breaks?
A common formula is =SUBSTITUTE(A1,CHAR(10)," "). It replaces line-feed characters in cell A1 with spaces and returns the cleaned text in another cell.
How can I remove line breaks in Word without removing paragraphs?
Use Find and Replace with ^l in the Find what field and a space in the Replace with field. The ^l code targets manual line breaks, while ^p targets paragraph marks.
Why does my Excel cell contain multiple lines of text?
A cell can contain line breaks inserted manually or included when text is copied from another source. In Excel, these breaks can often be identified and replaced using Find and Replace with Ctrl + J.
Can I remove line breaks from multiple Excel cells at once?
Yes. Select the range you want to modify, open Find and Replace with Ctrl + H, enter the line-break character using Ctrl + J in the Find what field, and then choose the replacement text. Always check the selected range before using Replace All.
How do I remove line breaks from a Google Sheets cell?
You can use Find and Replace where supported, or create a cleaned version with =SUBSTITUTE(A1,CHAR(10)," "). The formula replaces line-feed characters while leaving the original cell unchanged.
What is the difference between a line break and a paragraph break?
A line break moves text to another line without necessarily starting a new paragraph. A paragraph break separates one paragraph from another. Word represents these differently, which is why ^l and ^p have different effects when used in Find and Replace.
Ready to Clean Up Your Text?
Now you know how to remove line breaks in Excel, Word, Notepad++, and Google Sheets using the method that fits your workflow. For general plain-text cleanup, you can also use the free online line break remover.