Insert Line Breaks in Excel Cells with Find and Replace
Question details
Replace a character sequence, such as $$, with an in-cell line break in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user has cells containing a text marker and wants to convert every marker into the same line break created by Alt+Enter.
- Observed behavior
- The desired result is for the text after the marker to appear on a new line within the same cell.
Make sure the cells that will contain multiple lines have Wrap Text enabled, so the inserted line breaks are visible. Identify the exact marker to replace, such as $$, before running Replace All.
Replace a text marker with an in-cell line break in Excel
Use this method when a consistent marker, such as $$, appears in one or more Excel cells and should become an Alt+Enter-style line break.
In Excel, press Ctrl+H to open the Find and Replace dialog box.
In the Find what box, enter the character sequence to replace, such as $$.
Click in the Replace with box, then press Ctrl+J. The line-break character may not be visible in the box, but it is inserted.
Select Replace to review each match, or select Replace All to convert every matching marker in the current worksheet or selected range.
Select the affected cells and choose Home > Wrap Text if the lines do not display on separate rows within each cell.
Paste a line break from a helper cell when Ctrl+J is unavailable on Mac
Use this alternative on Excel for Mac if Ctrl+J does not enter a line break in the Replace with field.
Replace Text Markers with Line Breaks in WPS Spreadsheets
WPS Spreadsheets lets you find a repeated marker and replace it with an in-cell line break, helping you format imported or structured text without editing every cell manually.
- 1. Open Find and Replace: Open the worksheet in WPS Spreadsheets and press Ctrl+H.
- 2. Set the search text: Enter the marker, such as $$, in the Find what field.
- 3. Add the replacement line break: Click the Replace with field and enter or paste an in-cell line break character.
- 4. Replace the markers: Click Replace All to update all matching markers, or use Replace to confirm each occurrence.
- 5. Enable wrapped text: Select the updated cells and use Home > Wrap Text to make every inserted line visible.
Frequently Asked Questions
Why does the line break not appear after I use Replace All in Excel?
The line break may be present but hidden. Select the affected cells and choose Home > Wrap Text, then adjust the row height if needed.
Can I replace only $$ markers in selected Excel cells?
Yes. Select the target range before pressing Ctrl+H, then use Find and Replace. Excel applies the replacement to the selected cells when the selection is active.
What does Ctrl+J do in Excel Find and Replace?
When the cursor is in the Replace with box, Ctrl+J inserts a line-break character. Replacing a marker with that character creates a new line within the same cell.
Is an in-cell line break the same as creating a new Excel row?
No. An in-cell line break keeps all content in one cell and displays it on multiple lines. It does not insert a worksheet row or move data into another cell.
How can I add a line break in Excel for Mac if Ctrl+J does not work?
Create a helper cell containing a line break, copy the line-break character from that cell, and paste it into the Replace with field in the Replace dialog.
