Site icon ExcelNotes

Find and Replace Line Break in Excel

The line break in Excel can be a headache if you do not know the tricks, please see below how to work with the link breaks in excel cells.

Step 1: Select the cells in Excel and bring up the "Find and Replace" dialog box using shortcuts "Ctrl+F", "Ctrl+H", or the commands from the Ribbon: Home >> Find & Select >>Find;

Step 2: In the "Find what" box, type "Ctrl+J", and type space or anything in the "Replace with" box, and click "Replace All" button.

=FIND(CHAR(10),Cell)

Exit mobile version