How to Remove Line Breaks in Excel

Microsoft Forms responses can be downloaded as an Excel Spreadsheet; but the fields will often have unnecessary line breaks, which causes these fields' names to be discarded when importing the spreadsheet into an MS Access database.

Remove line breaks:

1. Open the Find & Replace box
2. Click on the Find field and press Ctrl + J on your keyboard
3. Leave the Replace field blank
4. Click "Replace All"
5. Save your workbook
6. Close and reopen Excel. This is necessary because Excel will automatically fill the Find field with whatever was last used, and it is impossible to delete line break characters from the Find field, so Find will be broken until Excel is restarted.