Find and Replace Alt+Enter in Excel: Remove Line Breaks

To find and replace an Alt+Enter line break in Excel for Microsoft 365 on Windows, press Ctrl+H, click the Find what box, press Ctrl+J, and enter what should replace the break. Leave Replace with empty to remove it, or type a space to separate the text on either side. Then choose Replace All or replace matches one at a time.

What Alt+Enter inserts in a cell

In desktop Excel for Windows, Alt+Enter inserts a line break inside the current cell. The cell still holds one value; the break simply moves subsequent text onto another line within that cell. For example, a cell might display “North” on one line and “Region” underneath it, while the formula bar shows both pieces as part of the same cell content.

That character is different from a normal space and from text wrapping. Wrap Text changes how Excel displays content when it reaches the cell edge, but it does not insert a character into the value. A manual line break remains part of the cell content even if you widen the column or turn off wrapping. This distinction matters: Find and Replace can target the actual break, but it cannot remove a visual wrap that was never inserted as a character.

Excel represents the usual in-cell line break as a line-feed character, which is why Ctrl+J is useful in the Find and Replace dialog. The shortcut does not appear as readable text in the box; it enters a control character. The blank-looking Find what box after pressing it is therefore expected.

Steps to find and replace the break

Select the cells you want to clean. If you select a range first, Excel searches within that selection; if you do not, the search normally applies to the active worksheet.
Press Ctrl+H to open Find and Replace. You can also open the Home tab and choose Find & Select > Replace.
Click inside Find what, then press Ctrl+J. Do not type the letters “Ctrl+J”; press the keys. The control character is invisible.
Click Replace with. Type a space, comma, dash, or other separator, or leave this box empty to delete the line break.
Choose Replace to review and change matches individually, or choose Replace All to change every match in the search scope.

After Replace All, Excel reports how many replacements it made. Check a few edited cells, especially if you applied the operation to a large range. If you are unsure about the result, use Ctrl+Z immediately to undo the replacement, then select a smaller range or replace matches individually.

Choose what goes in Replace with

Deleting a break is not always the same as cleaning up the text. If the cell contains “North” followed by a line break and “Region,” an empty replacement produces “NorthRegion.” That may be right for a code or a deliberate join, but it usually is not right for two words. A space produces “North Region,” which is easier to read and search.

Choose a replacement that preserves the meaning and the structure of the data:

Space: joins separate words, such as “First” and “Street,” without running them together.
Comma and space: can turn separate address or list lines into a readable single-line list.
Empty replacement: suits breaks inside a word or unwanted blank separators, but inspect the result for joined words.
Another line break: useful when replacing one kind of separator with a new in-cell break. In the Replace with box, Ctrl+J can enter a line-feed character as well.

A cell may contain more than one break. Replace All processes every matching break in the selected search scope, not just the first break in each cell. For example, three address lines become one line with spaces between them if you replace every break with a space.

Control the search scope and settings

Before choosing Replace All, confirm where Excel is looking. A selected range narrows the operation; without a selection, check the active sheet and any Find and Replace options that affect the search. In the expanded dialog, Within can set the search to the sheet or workbook. Choose Workbook only when you intend to change matching breaks across multiple worksheets.

Other options can affect what Excel matches. Look in determines whether it searches formulas, values, or notes, depending on the dialog and version. For ordinary text stored in cells, make sure the relevant cell content is being searched. If Replace All reports zero matches, revisit the scope and options before concluding that the cells contain no breaks.

It is sensible to test a representative cell first. Select just that cell, enter the line break in Find what, and use Replace. Once the result looks right, repeat on the intended range. If the workbook contains formulas, copied data, or carefully formatted labels, save a copy before making a broad replacement.

Common problems and what to check

The Find what box looks empty. That is normal: Ctrl+J enters a nonprinting character. Click the box and press the shortcut again rather than expecting a visible symbol. Be sure the insertion point is actually in Find what, not in the worksheet or another dialog field.

Excel finds nothing. First check that the cell has an inserted line break rather than ordinary wrapping. Then check the selected range, Within setting, and Look in option. Data imported from another system can also contain different control characters or a mixture of separators. Ctrl+J targets the usual Excel line feed; it will not necessarily match every unusual character present in imported text.

The result has words stuck together. This happens when the replacement is empty and the break separated words. Undo and repeat with a space or a more suitable separator. Also review consecutive breaks: replacing each with a space can leave repeated spaces where blank lines were present.

The cell still looks like it has multiple lines. It may contain another break, or Wrap Text may be displaying long text on multiple lines. Click the cell and inspect its content, or temporarily widen the column and turn off wrapping to distinguish display behavior from an actual line-feed character.

Use a formula when you want to keep the original

Find and Replace edits the selected cell contents directly. If you want to preserve the source data, use a helper column instead. With the original text in A2 and the cleaned result in B2, enter this formula in B2 to replace each line break with a space:

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

For example, if A2 contains “North,” a line break, and “Region,” the formula returns “North Region.” Fill the formula down for other rows by dragging the fill handle or copying it into the rest of the helper column. When the results are correct and you need fixed text, copy the helper cells and use Home > Paste > Paste Values to replace formulas with their displayed results. Keep the original column until you have checked the converted data.

The formula approach is useful when you need to compare cleaned output with source values, or when you need a repeatable cleanup that updates as the source changes. It does not alter A2; it returns a cleaned version in B2. If the goal is simply to edit a small set of cells once, Find and Replace is usually quicker.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. In Windows, Alt+Enter inserts the in-cell break, while Ctrl+H opens Replace and Ctrl+J enters the line-feed character in Find what. The menu route is useful if you do not use keyboard shortcuts: Home > Find & Select > Replace.

On a Mac, the shortcut for inserting a line break inside a cell differs; Excel commonly uses Control+Option+Return. Find and Replace is available from Excel’s Edit menu, and Control+J may enter the line-feed character in the dialog, depending on the keyboard mapping and Excel build. If it does not, use the helper formula with CHAR(10) rather than inserting a character you cannot verify. Excel for the web has a more limited interface than the desktop app, so the formula method is a practical fallback when the dialog will not accept the control character.

Frequently Asked Questions

What is the shortcut to find an Alt+Enter in Excel?

Press Ctrl+H, click Find what, and press Ctrl+J. Ctrl+J represents the line-feed character in the Find and Replace box; it is not the shortcut that inserts a break while editing a cell.

How do I remove an Alt+Enter without replacing it with anything?

Enter the line break in Find what using Ctrl+J, leave Replace with empty, and choose Replace All. Review the affected cells because removing a break between two words can join them together.

How do I replace an Excel line break with a space?

In the Replace dialog, put Ctrl+J in Find what and type one space in Replace with. Replace All changes every matching break in the chosen range or worksheet to a space.

Does Wrap Text mean a cell contains Alt+Enter?

No. Wrap Text changes the display of long content to fit the column. Alt+Enter inserts a line-feed character into the cell’s content. Find and Replace targets the inserted character, not a line break caused only by wrapping.

Can I replace line breaks in several worksheets at once?

Yes, when the Find and Replace dialog’s Within setting is set to Workbook. Check the workbook scope before using Replace All; otherwise, select a particular range or keep the search limited to the active sheet to avoid changing unintended cells.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.