1 – Select the cell(s) that contain line breaks you wish to remove
2 – Press CTRL + H on your keyboard. This opens up the “Find and Replace” dialog box.
3 – In the field “Find what” where you would normally type the word/text you want to replace, you need to enter the following : ALT + 010
>>> Keep the ALT key pressed, while typing 010 using the number keypad of your keyboard (problem if you’re working on a laptop, keyboard doesn’t include number pad). You should then see a dot appear briefly then disappear in the field “Find what”.
4 – In the field “Replace with”, just enter a space (a normal blank space using your keyboard space bar)
5 – Hit “Replace All”, and all your line breaks should be gone.
