Go to any table where a field has new lines in it. In my case it's varchar(8000).
Double click the table cell on that field.
The new lines are removed from the field, and clicking away from the field updates it with the new value. For example if you have this:
Double clicking gives you a textarea with: