I have cells within a worksheet that have text such as:

My first line
is continued
on three lines.

The weather
is stormy outside.
Should look like
My first line is continued on three lines.

The weather is stormy outside.
What I think I need is VBA that...
  1. delete a char(10)
  2. replace char(10) followed by a space with only one space
  3. replace two consecutive char(10) with only one char(10)


Any help would be greatly appreciated.