A line break inside an Excel cell is a single invisible character — typically CHAR(10) for LF or CHAR(13) for CR — that pushes text to a new visual line while keeping all of it in the same cell. To remove a line break from an Excel cell, paste the cell's content into the Line Break Remover tool, choose a mode (replace with space, remove entirely, or preserve paragraphs), and copy the cleaned text back into the cell. This approach handles the five line-break tokens Excel can actually accept inside pasted data: CRLF, standalone CR, standalone LF, U+2028, and U+2029. Inside Excel itself you can also use Find & Replace with Ctrl+J, the SUBSTITUTE function, CLEAN, or Power Query — but each handles a slightly different subset of those five characters, which is why hidden separators often survive even after you think you have cleaned them. The difference matters because Excel imports frequently inherit CRLF or LF from the source, while text copied out of document systems or page builders can carry U+2028 or U+2029 that looks identical to a regular newline in the cell viewer.
Why Excel cells collect invisible line breaks
The most common cause is copy and paste from a web page or PDF. HTML source uses CRLF, PDF extraction tends to use LF, and Word's clipboard format often preserves the line break the document was originally wrapped with. Once the line break lands inside a cell, Excel's wrap-text setting will redraw it visually without changing the underlying character, which is why a cell can still appear to contain a line break after you turn wrapping off.
Alt+Enter is the manual shortcut for inserting one of these characters directly. Power users also create them by importing CSV files whose field contains an embedded newline inside double quotes, by concatenating CHAR(10) into a formula, or by receiving data from an API whose JSON response includes literal \n. None of these sources distinguish between LF, CR, CRLF, and the two Unicode separators, so a cell can easily end up holding more than one kind in the same string.
The reason this matters for removal is that a tool which only searches for the literal "newline" that Excel calls Char(10) will silently miss anything else sitting inside the cell. That is usually the explanation when a cell still looks broken even after you have run several cleanup passes.
Removing line breaks with Excel's built-in tools
If you want to stay entirely inside Excel, four methods are commonly used. Each has a different scope, and the right one depends on what your data actually contains.
- Find and Replace with Ctrl+J. Select the range, press Ctrl+H to open Replace, click inside the Find what box, and press Ctrl+J to insert a line-break character. Leave Replace with empty to delete the breaks, or type a single space if you want to join lines. Click Replace All. This handles the LF and CRLF Excel typically stores, but it does not target U+2028 or U+2029.
- SUBSTITUTE formula. In a helper column, write =SUBSTITUTE(A1, CHAR(10), " ") to replace LF with a space, or =SUBSTITUTE(SUBSTITUTE(A1, CHAR(13), " "), CHAR(10), " ") to handle both CR and LF. Wrap the result in TRIM if you also want to collapse any double spaces the substitution creates.
- CLEAN function. =CLEAN(A1) strips the first 32 non-printing characters from the 7-bit ASCII range, which covers LF and CR. It does not touch U+2028, U+2029, tabs, or non-breaking spaces.
- Power Query. Load the range into Power Query, use Replace Values with the special character #(lf), #(cr), or both as the value to find. This is the most reliable in-Excel option for files you will refresh regularly.
For a single quick cleanup where you do not want to write formulas or load Power Query, the single-step Excel cleanup walks through the Ctrl+J workflow in more detail. If, however, you also want to remove U+2028 and U+2029 in the same pass — or you want to know exactly how many breaks were detected and how many were actually removed — Excel's built-in tools will not give you that confirmation by themselves.
A faster option that handles every break type
The Line Break Remover tool on Lizely recognizes all five line-break tokens in one operation: CRLF counted as one combined token, plus standalone CR, standalone LF, and the Unicode line separators U+2028 and U+2029. Recognition happens against the actual Unicode code points rather than the visual rendering, so a separator that looks identical to a regular newline but is in fact U+2029 will still be counted and replaced.
The transformation runs entirely inside the current browser tab. Nothing is uploaded, the text never leaves the page, and the output area keeps the result visible so you can copy it manually if the clipboard button cannot access the system clipboard. Because the tool reports detected, removed, and remaining token counts, you can verify that the input actually contained the breaks you expected before you paste the cleaned text back into Excel.
Using Line Break Remover on cell content
To process one or more cells through the tool, copy the cell content from Excel, switch to the browser tab hosting Line Break Remover, paste the text, and pick the mode that matches what you want the output to look like.
- Paste the cell text and choose a mode. Drop the content into the input area, then select one of three explicit options: replace every line-break token with one ordinary space, replace every token with an empty string (full removal), or preserve paragraph boundaries while joining single wrapped lines.
- Process the text and review the counts. Trigger the transformation. The result panel shows how many line-break tokens were detected in the input, how many were removed, and how many remain. Replace and remove modes always report zero remaining; paragraph mode reports remaining tokens equal to twice the number of multi-break runs that represented paragraph boundaries in your source.
- Copy the output, or select it manually. Use the copy button if the browser has clipboard permission. If clipboard access is unavailable, the transformed text remains visible in the output area and can be selected with the mouse for a regular copy. Once copied, return to Excel and paste the cleaned text back into the original cell.
If you need to edit the input or switch modes, do that before pasting the output back into Excel. Editing the input or changing the mode clears the previous result, the counts, and any clipboard status from the panel, so you will not accidentally paste a stale result.
Which mode matches your data
The three modes are not interchangeable. Each one makes a specific, documented change to every recognized line-break token, so pick the one that matches the shape of the source you copied out of Excel.
| Mode | What it does to each token | Result statistics | Best for |
|---|---|---|---|
| Replace with one space | Every recognized line-break token becomes exactly one U+0020 space. Two consecutive tokens therefore become two spaces. | Detected equals removed; remaining is zero. | Joining hard-wrapped prose, cleaning chat exports, preparing prompt text, joining address lines. |
| Remove completely | Every recognized line-break token becomes the empty string. Words separated only by a break are joined directly. | Detected equals removed; remaining is zero. | Stripping record separators, flattening machine-generated exports, joining identifiers. |
| Preserve paragraphs | A run of exactly one token becomes one space. A run of two or more tokens becomes exactly two LF characters. Non-newline whitespace between tokens keeps them in separate runs. | Detected equals removed plus remaining. Each multi-token run reports two remaining; tokens beyond two in a run count as removed. | Normalizing pasted paragraphs that use blank lines as boundaries, cleaning PDF text where page breaks add blank-line gaps. |
When in doubt, start with replace with space. It is the only mode that is safe on natural language because it cannot accidentally merge two words together. Switch to remove completely only when you have confirmed that the breaks were never load-bearing separators, such as inside a fixed-format record or token.
What Line Break Remover deliberately preserves
The tool is scoped strictly to the five recognized line-break tokens. Spaces, repeated spaces, tabs, non-breaking spaces, and any leading or trailing non-newline whitespace survive unchanged. Punctuation, letters, digits, and combining marks are not modified, normalized, or removed. The tool never trims the beginning or end of the input, collapses repeated spaces, expands tabs, or touches non-breaking spaces.
Two limits govern what the tool will accept. The input budget is 1,000,000 UTF-16 code units; one unit above that is rejected before transformation with an explicit message rather than silently sliced. An empty input also reports an error instead of presenting a misleading success. Whitespace-only input, by contrast, is valid because preserving non-newline whitespace is part of the contract.
If your goal is to remove every kind of whitespace character rather than only line breaks, you would need a different tool. For line-break work specifically, the combination of explicit modes, accurate counts, and copy-ready local output makes the tool a reliable companion to Excel's own cleanup methods, especially when the source data may carry Unicode line separators that Find and Replace with Ctrl+J cannot see.