Want to remove a line break in Excel? Follow the steps below!
- In Excel, choose Edit>Replace
- Click the “Find what” box
- Hold the Alt key, and (on the number keypad), type “0010”. This represents a line break in Excel. You won’t see anything in the “Find What” box
- In the “Replace with” box, type the characters that you want to use instead of a line break
- Click the “Replace All” button.