To find and replace an Enter line break inside Excel cells, press Ctrl+H, click the Find what box, press Ctrl+J, enter the replacement, and choose Replace or Replace All. The Find what box will look blank: Ctrl+J represents the line-feed character Excel uses for an in-cell line break.
What Enter means inside an Excel cell
In Excel, pressing Enter normally finishes editing a cell and moves the selection to another cell. That action is different from inserting a line break within the cell’s text. To add a line break while editing a cell, use Alt+Enter on Windows. On Mac, the shortcut is Control+Option+Return. The resulting line break is commonly called a line feed and is represented in Excel formulas by CHAR(10).
This distinction matters when cleaning imported or manually entered text. A cell might contain a name, address, or note split across two or more display lines, even though all the text is stored in one cell. Find and Replace can locate those in-cell breaks, so you can remove them or replace them with a space or another separator. It does not search for the ordinary Enter key press that moved you out of a cell.
Find and replace a line break step by step
- Select the cells you want to change. If you do not select a range, Excel can search the current worksheet or workbook, depending on the search settings.
- Press Ctrl+H to open Find and Replace. You can also use Home > Find & Select > Replace.
- Click in the Find what box, then press Ctrl+J. Do not type the characters Ctrl+J; press the keys together. The box will appear empty, which is expected.
- Click in Replace with and type what should appear instead. Leave it empty to remove the line break, or type a space to join the text with a gap.
- Choose Find Next to check a match, Replace to change one match, or Replace All to change all matches in the selected search scope.
On Mac, open Replace from Home > Find & Select > Replace, or use the Edit menu’s Find and Replace command if that is how your Excel version presents it. In the Find what field, use Control+J for the line-feed character; the key combination is not Command+J. If your keyboard layout or Excel version does not insert the character this way, use the formula-based method below instead.
Choose what should replace the break
The right replacement depends on what the line break means in the data. Removing every break can make text run together, while replacing every break with a space is often appropriate for sentences or addresses. A delimiter such as a comma may make sense when the lines represent separate items.
- Replace with nothing: turns “North” followed by a line break and “Wing” into “NorthWing.” Use this only when joining the words without a separator is intended.
- Replace with a space: turns the same content into “North Wing.” This is a useful general choice for names, notes, and sentences.
- Replace with punctuation: a comma and space can turn separate address lines or list items into a more readable single line.
Find and Replace substitutes each matching line-feed character. If a cell contains two consecutive breaks, replacing each with a space can leave two spaces. You can run a second cleanup or review the results. Where blank lines separate meaningful sections, consider whether removing them would make the data harder to understand before using Replace All.
Control the search scope and options
Before choosing Replace All, confirm where Excel is searching. If you selected a range, the operation can be limited to that selection; without a selection, check the Within setting to choose the current sheet or workbook. A workbook-wide replacement can affect sheets you are not currently viewing, so check the scope rather than assuming it is limited to the active sheet.
The Replace dialog also has search options, including whether to look in formulas or values. For ordinary text entered directly into cells, the replacement is straightforward. If cells contain formulas, take extra care: searching formulas can locate text in the formula itself, while a displayed line break may instead be created by a formula or come from its source data. In that case, changing the formula text may not be the right fix. Find and Replace may also retain search settings from an earlier search, so review the dialog’s options if the results are unexpected.
It is sensible to test a small selection first. Find Next lets you inspect a match before changing it, and Replace lets you apply the change one match at a time. For a large or important workbook, save a separate copy before a broad replacement; a replacement can alter many cells at once, and Undo may not be a dependable recovery plan after later actions or closing the file.
Why Ctrl+J can appear to do nothing
The blank-looking Find what field is the most common source of confusion. Excel does not display a visible symbol for the line feed there, so the keystroke can work even when the field looks empty. After entering Ctrl+J, try Find Next in a cell you know contains an in-cell line break. If Excel finds a match, the search term is present.
If no match appears, check these likely causes:
- The selection or scope is too narrow: clear an unintended selection or set Within to the appropriate worksheet or workbook.
- The text is not in the cell you expected: the displayed content may overflow from a nearby cell, or the break may be in a different column.
- The line is visual wrapping, not a stored break: Wrap Text can display content on multiple lines because of column width. Widen the column or turn off wrapping to check; a visual wrap is not a character for Ctrl+J to find.
- The content is formula-generated: inspect the formula and its source cells rather than assuming the displayed line break is directly stored in the cell.
- A previous search option is affecting results: check the selected sheet or workbook, search location, and any formatting criteria in the dialog.
Also distinguish an in-cell line break from a paragraph mark or carriage-return character in text imported from another system. Excel commonly uses CHAR(10) for an in-cell break, but imported text can contain other control characters. If Ctrl+J finds only part of the problem, clean a copy of the data with a formula or inspect the source file before making a global change.
Use a formula when you want to keep the original data
A formula can create a cleaned version in a new column, leaving the original values untouched for comparison. With the text to clean in A2, enter =SUBSTITUTE(A2,CHAR(10)," ") in another cell. This replaces every line-feed character in A2 with a space. For example, if A2 contains “17 Oak Street” followed by a line break and “Unit 4,” the result is “17 Oak Street Unit 4.” Copy the formula down for other rows, then inspect the results before deciding whether to copy and paste them as values over the original data.
If an imported cell may contain both carriage returns and line feeds, you can remove both character types with =SUBSTITUTE(SUBSTITUTE(A2,CHAR(13),""),CHAR(10)," "). Here A2 is the source cell; the formula removes CHAR(13) and changes CHAR(10) to a space. This approach is useful when a data source uses a carriage-return/line-feed pair. It does not identify every possible invisible character, so check representative records if the cleanup is incomplete.
Formulas are preferable when you need a reversible transformation, want to compare before and after, or need to preserve the original imported data. Find and Replace is usually faster for a one-time, confirmed change. In either case, inspect a few results: replacing a break with a space can create doubled spaces, and removing a break can join words or values that should remain separate.
Check the result and preserve useful formatting
After replacing line breaks, review several changed cells, including ones with multiple lines and unusual punctuation. If text now looks cut off, the content may still be present but the row height or column width may need adjustment. Wrap Text controls how text displays; it does not insert or remove line-feed characters. Likewise, changing row height only changes the view, not the underlying text.
Find and Replace changes cell content, not just its appearance. If the affected cells have formulas, links, or carefully structured text, verify that those still behave as intended. A practical workflow is to duplicate the worksheet, run the replacement on the copy, compare the results, and then keep the cleaned data only after confirming that important information remains intact.
Frequently Asked Questions
How do I find an Enter character in Excel?
Press Ctrl+H, click Find what, and press Ctrl+J. The field looks blank because Excel does not show a visible marker for the line-feed character. Use Find Next to confirm a match before replacing it.
How do I remove line breaks without adding spaces?
In Find and Replace, enter Ctrl+J in Find what and leave Replace with empty. Select the intended range or confirm the sheet or workbook scope before choosing Replace All.
How do I replace an Enter with a space in Excel?
In the Replace dialog, put Ctrl+J in Find what and type one ordinary space in Replace with. This keeps words separated when the line break is removed.
Why does Ctrl+J look blank in the Find box?
The line feed is a control character, not printable text. Excel’s dialog does not display a special symbol for it, so an empty-looking box can still contain the search character.
Does Find and Replace remove text that wraps onto another line?
No. Text can appear on multiple lines because Wrap Text and column width control its display. Find and Replace with Ctrl+J targets an actual in-cell line break, not a visual wrap.