Home About project

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".