How do you remove hard returns in an Excel spreadsheet?

If they are in the middle of a cell there are a few things you can do. You can turn off wrap text. Press Ctrl-1 and go to the Alignment settings and if it is on, you can turn it off by removing the tick. If the hard return has been put in by the user, find the point in the text where it is, press F2 to edit the cell and use the Delete or Backspace key to remove it.