Remove Line Breaks in MS Excel

If you need to remove line breaks from text in MS Excel you can do the next simple actions:

1. Ctrl+H to open the Find & Replace dialog box.
2. In the "Find what:" box you can enter the line-break code. To do this, press and hold the Alt key, and then enter the numbers 010 from the numeric part of the keyboard.
3. For the replacement, use " " (space).
4. Click on "Replace All".