Removing Line Breaks in a Google Spreadsheet

  1. Edit menu > Find and Replace
  2. Paste this in the Find box: \r\n|\n|\r
  3. Check the “Search using regular expressions” box
  4. Replace All