To strip line breaks from text inside Google Sheets cells you have three reliable paths: Find & Replace with the Ctrl+J shortcut, a SUBSTITUTE formula built around CHAR(10), or an external tool that recognizes all five standardized break tokens. The Ctrl+J trick is the fastest fix for a single column because it replaces every line-break character with whatever you type in the Replace box, and a single space is almost always the right substitute. The SUBSTITUTE route is best when you want the result in a helper column rather than overwriting the original, because formulas keep the source intact and stay auditable cell by cell. An external browser tool is the safest choice when your text was pasted in from a PDF, an export, a form response, or another spreadsheet, because those sources often carry hidden CR, CRLF, U+2028, or U+2029 characters that Ctrl+J misses and SUBSTITUTE only catches when you write CHAR(10) for every single one. All three approaches are valid; what changes is how much control you keep over spaces, tabs, and the paragraph boundaries that still mean something in the source.
What Line Breaks in Google Sheets Cells Actually Are
Google Sheets writes line breaks as a single LF character, which is the same character CHAR(10) returns and which the Find and Replace dialog matches when you press Ctrl+J (Cmd+J on macOS). If you insert a line break with Alt+Enter (or Option+Enter on macOS) inside a cell, Sheets stores one LF; if you build it with a formula that uses CHAR(10), it also stores one LF; if you paste in text from another tool, you can quietly bring in CRLF (the Windows pair), standalone CR (the old Mac byte), and even Unicode line separators U+2028 and U+2029, which look like soft returns but count as distinct code points. According to the MDN JavaScript lexical grammar reference, those five forms are precisely the line terminators the browser recognizes as breaks, and a tool that only matches LF will leave the others behind where your data can still fail a CONCATENATE call, an export, or a search. Knowing which forms live in your data is what tells you whether an in-cell fix is enough or whether the text needs to leave the sheet for a moment.
Quick Fixes Inside the Sheet (And What They Miss)
For a small range, the Ctrl+J trick is genuinely fast. Open Edit > Find and replace, click inside the Find box, press Ctrl+J (the field looks empty, but Sheets now holds a line break), type a single space in the Replace box, choose All or a specific range, and hit Replace all. Cells collapse onto one line and the original spacing between words survives if you typed exactly one space. The SUBSTITUTE formula does the same job in a helper column:
=SUBSTITUTE(A1, CHAR(10), " ")
Drag it down to clean an entire column without overwriting the source. For tab-style separators that were pasted in as line breaks, swap CHAR(10) for CHAR(9). For a regex variant, REGEXREPLACE(A1, "\n", " ") works as well, though it requires Sheets to interpret the literal "\n" inside the pattern argument, which it does.
The honest limit of every formula is that it can only match what the sheet sees. CRLF arrives as CHAR(13) followed by CHAR(10), and a formula that only targets CHAR(10) leaves a stray carriage return in your cell. U+2028 and U+2029 do not match any CHAR() function in Sheets, so they survive every in-cell formula. If your paste contained any of those, the cell still has hidden breaks even after a successful Replace all, and a SUBSTITUTE inside Sheets will quietly claim victory while the export pipeline trips on the same hidden character.
Clean Line Breaks Outside the Sheet With Line Break Remover
- Copy the cell, column, or range that contains the line breaks and paste it into the input box of the Line Break Remover.
- Pick the mode that matches what you want the text to become: Replace with one space for prose, Remove completely for record separators, or Preserve paragraphs for blocks like addresses where blank lines still mean something.
- Click the process button. The tool accepts inputs up to 1,000,000 UTF-16 code units; anything larger is rejected before transformation with an explicit message. The result panel shows the count of detected tokens, the number removed, and how many remaining line breaks (if any) the result still contains.
- Use the Copy button to send the cleaned text to your clipboard. If the browser denies clipboard access, the output stays selectable so you can copy it manually with Ctrl+C.
- Paste the cleaned result back into the original cell or column. If you processed a helper column first, copy the results and use Edit > Paste Special > Values only into the source range to replace the originals without dragging formulas along.
All five break forms, including CRLF, CR, LF, U+2028, and U+2029, are matched and counted in a single pass, and CRLF is treated as one token rather than two. The tool runs entirely in your browser, so the text never leaves the tab and no account, file upload, or dependency is needed.
Which Mode to Pick — Replace, Remove, or Preserve Paragraphs
The three modes are not stylistic preferences; they make different promises about what your text will look like afterward. Picking the wrong one is how you end up with merged words, awkward double spaces, or paragraphs that quietly disappear.
| Mode | What it does to each break | Best for | Watch out for |
|---|---|---|---|
| Replace with one space | Every recognized token becomes one U+0020 space. | Hard-wrapped prose, joined addresses, paragraphs that flowed at a fixed column width. | Two breaks in a row produce two spaces; the tool does not collapse them. |
| Remove completely | Every recognized token is deleted, so words separated only by a break are joined directly. | CSV exports, record separators, code snippets, anything where no space is expected. | Apply this to natural language and "white house" can become "whitehouse". |
| Preserve paragraphs | A single token becomes one space. An uninterrupted run of two or more tokens becomes exactly two LF characters — one normalized blank line. | Address blocks, form responses, survey text where blank lines mark real paragraph breaks. | Non-newline characters between breaks keep them in separate runs, so LF + space + LF becomes three spaces. |
The mode only transforms the actual break tokens; it never trims the start or end of the text, never collapses repeated spaces, never touches tabs or non-breaking spaces, and never alters letters or punctuation. That guarantee is what lets you preview the output and trust it before you paste the result back into a sheet.
The Five Line-Break Tokens the Tool Recognizes
The other reason to clean the text outside the sheet is that Sheets cells can quietly contain break forms no built-in formula can match. Knowing which form you are dealing with explains why an in-sheet fix appeared to succeed while leaving the data still broken.
| Token | Common name | Typical source |
|---|---|---|
| CRLF (U+000D U+000A) | Windows line break | CSV exports from Windows tools, copy-paste between Office and Sheets. |
| LF (U+000A) | Unix / Sheets line break | Alt+Enter inside a cell, CHAR(10) formulas, plain text exports. |
| CR (U+000D) | Classic Mac line break | Older Mac files, certain legacy form generators. |
| U+2028 | LINE SEPARATOR | Document systems, some web copy that round-trips through a CMS. |
| U+2029 | PARAGRAPH SEPARATOR | Document systems, export pipelines from publishing tools. |
CRLF is counted as a single token, so a Windows paste that contained ten hard line breaks reports ten detected and ten removed in replace or remove mode, not twenty. In paragraph mode, ten separate tokens become ten spaces with zero remaining, while ten consecutive tokens collapse into one run that maps to exactly two LF tokens — so paragraph mode never reports ten remaining. The statistics panel reports tokens rather than raw code units, which is why a CRLF that looks like two bytes counts as one removal.
Putting the Cleaned Text Back Into the Sheet
The simplest round-trip is: copy the cleaned result, click the original cell, and press Ctrl+V. If the cell was formatted with bold, color, or wrap, the paste drops the result back into the same cell and keeps the cell's display attributes intact. For a column that you cleaned via a helper column, copy the helper column's results, select the original column, and use Edit > Paste Special > Values only so the cleaned text replaces the formulas without dragging any REGEXREPLACE or SUBSTITUTE references along.
If the sheet pulls from an upstream range with IMPORTRANGE or IMPORTDATA, the cleanup belongs upstream. Paste the cleaned text back into the source sheet, or paste the result into a static range and point the downstream formulas at it instead. Re-importing the dirty original will just bring the hidden breaks back on the next refresh.
For a one-off paste into a single cell where you want to preview the change without committing, drop the cleaned text into an empty cell beside the source and read the row with a side-by-side comparison. Once it looks right, paste it over the original. The result panel of the Line Break Remover also reports a remaining count after paragraph mode, which counts the two normalized LF tokens produced for each preserved paragraph boundary — so the remaining count is twice the number of paragraph boundaries, not the count of blank lines themselves. That figure is what tells you whether an address block kept its structure or quietly collapsed into one.
For a deeper look, see How to Count Lines in Word When the Status Bar Lies.
For a deeper look, see How to Randomize a List in Word in 3 Steps.