If you need to remove line breaks from text in MS Excel you can do the next simple actions:
- Ctrl+H to open the Find & Replace dialog box.
- 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.
- For the replacement, use " " (space).
- Click on "Replace All".