In the Find what box, press Ctrl+J. This is the code for a line break. Leave the Replace with box empty. Either use Find Next / Replace, or click Replace All if you want to remove all line breaks.
How do you remove line breaks in Excel?
How do I remove line breaks in my Excel file?Open the Find/Replace command window.Place your cursor in the Find what box. Press and hold the Alt key and then enter “010” from the 10-keypad portion of your keyboard. Place your cursor in the Replace with box. Press your space bar once. Click Replace All.
What is a line break in code?
A. L. The end of a line of text in electronic form. Also called EOL (end-of-line), newline, and hard return, a line break code is generated when the Enter key is pressed, When typing a command on a command line, pressing Enter executes the command.