How to Remove line breaks _x000D_ from Excel data sheet


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.


Leave a Reply

Your email address will not be published. Required fields are marked *