I am trying to improve a spreadsheet a colleague started. There are a ton of
carriage returns within cells.

1. How can I get rid of the carriage returns?
and
2. Is there some way I can get rid of the carriage returns, but have the
existing text in the cell distributed vertically in unused cells?

Thanks in advance for the help, I can provide more detail if it is needed.