How to Remove line breaks _x000D_ from Excel data sheet

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)