How to Remove Line Breaks in Excel (Formulas & Shortcuts)

Importing data into Excel should be a smooth process, but all too often, data from external systems, CRMs, or web forms comes littered with unwanted line breaks inside the cells. This ruins sorting, breaks VLOOKUP formulas, and makes your spreadsheet impossible to read.

If you're wondering how to remove line breaks in Excel, you have a few options. While you could manually click into every cell and hit backspace, there are much faster ways to clean thousands of rows in seconds.

In this guide, we'll walk through three native Excel methods to strip out line returns, plus a bulletproof "zero-formula" method using our free Remove Line Breaks Tool.

Method 1: The CLEAN Formula (Best for General Cleanup)

Excel has a built-in function called CLEAN specifically designed to strip non-printable characters — including line breaks — from text.

1. Insert a new blank column next to the column containing your messy data.
2. In the first cell of the new column, type: =CLEAN(A1) (assuming your messy text is in A1).
3. Press Enter. The text will appear without the line break.
4. Drag the fill handle (the small square at the bottom right of the cell) down to apply the formula to the rest of the rows.
5. To make the change permanent, copy the new column, right-click, and select Paste as Values over the original data. You can then delete the formula column.

Method 2: Find and Replace (Fastest In-Place Fix)

If you don't want to mess around with helper columns and formulas, you can use Excel's Find and Replace tool. The trick is knowing the keyboard shortcut for a line break.

1. Highlight the column containing the line breaks.
2. Press Ctrl + H to open the Find and Replace dialog box.
3. Click into the "Find what" field. Hold down Ctrl and press J (this is the shortcut for a carriage return in Excel). The box will look empty, but you might see a tiny blinking dot.
4. Click into the "Replace with" field and type a single space (hit the spacebar once).
5. Click Replace All.

Replacing the break with a space prevents the last word of the first line from mashing into the first word of the next line (e.g., turning "San
Francisco" into "SanFrancisco").

Method 3: The SUBSTITUTE Formula (For Stubborn Line Breaks)

Sometimes the CLEAN function doesn't work because it only targets specific non-printable ASCII characters. If your line breaks are surviving Method 1, you can explicitly target character 10 (the line feed character).

 1=SUBSTITUTE(A1, CHAR(10), " ")

This formula tells Excel to look at cell A1, find any instance of CHAR(10) (a line break), and swap it out for a space. If your data came from an older Mac or a specific Unix system, the break might be a carriage return instead. In that case, use CHAR(13):

 1=SUBSTITUTE(A1, CHAR(13), " ")

Like Method 1, you'll need to copy the results and "Paste as Values" to finalize the cleanup.

Method 4: The Zero-Formula Web Tool

If you only have a few paragraphs to fix, or you are uncomfortable writing Excel formulas, the easiest method is to bypass Excel entirely using our Remove Line Breaks Tool.

• Copy the broken text out of your spreadsheet.
• Paste it into the tool.
• Click copy, and paste the clean, flowing text back into Excel.

This tool automatically handles the difference between Windows (CRLF), Mac (CR), and Linux (LF) line breaks, so you don't have to worry about whether to use CHAR(10) or CHAR(13).

Why "Wrap Text" Doesn't Fix the Problem

A common mistake when trying to hide line breaks is clicking the "Wrap Text" button in the Home ribbon. Un-checking Wrap Text makes the cell look like a single line, but the line break character is still hidden inside the data.

If you try to export that data as a CSV, upload it to a database, or run an exact-match formula, it will fail because the hidden break is still taking up space. You must actually remove the character using one of the methods above, not just hide it visually.

Summary

Unwanted line breaks in Excel can bring your data analysis to a halt. For quick in-place fixes, the Ctrl+J Find and Replace method is unmatched. For systemic cleanup on thousands of rows, rely on the CLEAN or SUBSTITUTE formulas. And if you want to skip the spreadsheet acrobatics entirely, a dedicated web formatter is the easiest path to clean text.