Excel Find and Replace Paragraph Mark: The Right Method

In Excel for Microsoft 365 on Windows, press Ctrl+H, click the Find what box, and press Ctrl+J to search for a line break inside cells; enter the replacement in Replace with, then choose Replace All or Replace. Excel does not use Word’s paragraph-mark character in cells: the mark people usually mean is a line-feed character, which Ctrl+J can represent in the Find and Replace dialog.

What Excel means by a paragraph mark

In Word, paragraph marks identify paragraph endings and can be shown as pilcrow symbols (¶). Excel cells do not contain Word-style paragraphs. A cell can contain a line break, however, so text appears on separate lines while remaining in one cell. People often call that break a paragraph mark, even though “line break” or “line feed” is the more accurate description.

In a typical Excel cell, a line break is the character represented by CHAR(10). On Windows, you can insert one while editing a cell by pressing Alt+Enter. For example, a cell might contain “North region,” then a line break, then “Sales team.” That is still one cell value, not two rows or two paragraphs in separate cells. The cell may need Wrap Text enabled or a taller row to display both lines.

This distinction matters because searching for the visible symbol ¶ will not usually find a cell’s line break. The symbol is not necessarily present in the cell at all; it may only be a way a person describes the break. Search for the actual line-feed character instead.

Find a line break with Ctrl+J

Use the Find and Replace dialog to locate cells containing the break. In Excel for Microsoft 365 on Windows, the steps are:

Select the worksheet or range you want to search. If you select a range first, Excel can limit the operation to that selection.
Press Ctrl+H to open Replace. You can also use Home > Find & Select > Replace.
Click inside Find what, then press Ctrl+J. The box may look empty afterward. That is normal: the control character does not display like ordinary text.
Choose Find Next to check for a match, or fill in Replace with and choose Replace or Replace All.

For instance, suppose a cell contains “Avery Chen” on the first line and “Operations” on the second. To find that line break, enter Ctrl+J in Find what. The dialog searches for the break character within the cell text; it does not search for the words “Avery Chen” or “Operations.” If you want to target a particular phrase as well as a break, search for the phrase and break together, taking care to enter the line break at the right position.

Find and Replace usually searches the current sheet by default. Open the dialog’s options if you need to change the search scope, such as searching the whole workbook, or adjust what Excel searches. Check the scope before using Replace All: a workbook-wide replacement can change more cells than intended.

Replace the break with a space or other text

The replacement depends on what the text should read like after the break is removed. A space is often appropriate when two lines are parts of the same sentence or name. For example, replacing the break in “Avery Chen” and “Operations” with a space produces “Avery Chen Operations.” Replacing it with nothing produces “Avery ChenOperations,” which may join words together.

Common choices include:

A single space: Use this to join separate lines into readable continuous text.
Nothing: Use this when the break separates symbols or fragments that should touch, and inspect the result for accidentally joined words.
A separator: Use a comma, semicolon, hyphen, or another delimiter when the lines should remain visibly distinct in one line.
Another line break: In the Replace with box, press Ctrl+J if you need to substitute a different line break character. Test on a small range before applying it broadly.

After entering the replacement, use Replace first if you want to inspect changes one at a time. Replace All is faster but applies to every match within the selected range or current search scope. Excel reports how many replacements it made; that count is a useful check, though it does not replace reviewing the resulting data.

Remove line breaks with a formula instead

Find and Replace changes the cell contents directly. A formula is useful when you want to preserve the original text, create a cleaned version in another column, or make the cleanup repeatable. With the text to clean in A2, enter this in B2:

=SUBSTITUTE(A2,CHAR(10)," ")

For example, if A2 contains “Avery Chen” followed by a line break and “Operations,” the formula in B2 returns “Avery Chen Operations.” The formula replaces each line-feed character with one ordinary space. Fill it down for additional rows. When the results are correct and you need to replace the originals, copy the formula results and use Paste Special > Values over the original cells. Keep a backup first if the source text matters.

If your goal is to remove line breaks without inserting spaces, use =SUBSTITUTE(A2,CHAR(10),""). That returns the two text fragments joined directly together, so it is best for data where the join is intentional. The formula only changes the formula result; it does not edit A2 itself.

Why Ctrl+J may seem not to work

The most common confusion is that Ctrl+J appears to do nothing. The line-feed character is invisible in the dialog, so a blank-looking Find what field does not prove that it was entered incorrectly. Try Find Next on a cell you know contains an in-cell break, or test on a copy of the data and check the number of replacements.

Other issues can have different causes:

The cell only looks like it has multiple lines: It may contain ordinary text that wraps because the column is narrow. Widen the column or inspect the cell in the formula bar. Wrapped display alone is not a line-break character.
The break was typed in a different way: A line break inserted with Alt+Enter is the usual case. Imported text may also include tabs, carriage returns, or other control characters. A search for Ctrl+J will not necessarily remove every kind of unwanted character.
Excel searches the wrong place: Check whether the dialog is searching the active sheet or the workbook, and whether a selected range limits the search.
The dialog contains old settings: Review the search options and make sure the replacement text is what you intend. A prior search scope or other option can affect results.
The selected cells are formulas: Find and Replace can behave differently depending on whether Excel is looking in formulas or displayed values. Review the Look in setting in the dialog, and consider using a helper formula when you need to clean the text produced by a formula without changing its source formula.

For imported or messy text, CLEAN can remove many nonprinting characters, but it may remove control characters beyond the line break you intended to replace. A targeted SUBSTITUTE formula gives more control. If one line break remains after replacing Ctrl+J, inspect a sample with formulas or use a data-cleaning step appropriate to the actual characters rather than assuming every invisible mark is identical.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. On Windows, Ctrl+H opens Replace, and Ctrl+J enters the line-feed character in the dialog’s focused text box. You can also open Replace from Home > Find & Select > Replace.

Excel for Mac has a Find and Replace command as well, but keyboard shortcuts can differ by keyboard and Excel version. Open the Replace dialog from the ribbon or Excel’s menus and use its fields; do not assume a Windows shortcut will behave identically on a Mac. The common Mac shortcut for inserting a line break while editing a cell is Control+Option+Return, rather than Windows Alt+Enter. That shortcut inserts a break in the cell; it is separate from entering a search character in the dialog. Excel for the web also provides Find and Replace, though the dialog and shortcut behavior can vary from the desktop app. If the invisible-character shortcut is unreliable in your version, use a formula with CHAR(10) as a controlled alternative.

Find and Replace versus other cleanup methods

Choose Find and Replace when you want a quick, permanent edit across a selected range or sheet. It is direct and does not require adding a helper column, but it is easy to change too much if the scope is broad. Consider copying the source range or saving a workbook copy before a large Replace All operation.

Choose a formula when you need to retain the original values, compare before and after, or repeat the same transformation on refreshed data. A helper column makes the outcome visible and reversible while the original remains intact. For larger recurring imports, Power Query can also clean text during a repeatable data-import process; it is more setup than a one-off replacement but avoids manually repeating the same cleanup on every refresh.

Do not confuse line breaks inside cells with paragraph marks in Word, line breaks between worksheet rows, or wrapped text caused by column width. Find and Replace with Ctrl+J addresses the line-feed character inside a cell. It does not merge worksheet rows, change row height, or turn a Word document’s paragraph marks into Excel characters.

Frequently Asked Questions

How do I find a paragraph mark in Excel?
Press Ctrl+H, click Find what, and press Ctrl+J on Windows. Excel treats the usually invisible character as an in-cell line feed. Choose Find Next to check for a match.

How do I replace a line break with a space in Excel?
Enter Ctrl+J in Find what, type one space in Replace with, then choose Replace All or replace matches individually. Check that the search scope covers only the cells you mean to change.

Why does Ctrl+J leave the Find what box blank?
The line-feed character is not printable, so the box can look empty even when Ctrl+J entered the search character. Test on a known cell with a manually inserted line break rather than judging by the field’s appearance.

Does Excel have a paragraph mark like Word?
No. Excel cells can contain line-feed characters that start a new displayed line, but they are not Word paragraph marks. The Word pilcrow symbol is not the character to search for in a typical Excel cell.

Can I remove line breaks without changing the original cell?
Yes. Put =SUBSTITUTE(A2,CHAR(10)," ") in a helper cell when the source is in A2. It returns cleaned text in the helper cell and leaves the original value unchanged until you choose to replace it.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.