Formatting And Removing Carrage Returns

I have data in excel I exported from Crystal Reports. Within a cell there is data containing odd characters, plus carriage returns, so each cell has for or five lines of data. For example:

Job 3090/3276/41700
#
#
#
Inspect Clean And Test Gullies and or drains, wash down with at least 2 buckets of water.

In by example above I have used # as the rouge character, but in my spread sheet there are square symbols.

Is it possible to remove the "#" and more importantly the carriage returns, so I end up with:

Job 3090/3276/41700 Inspect Clean And Test Gullies and or drains, wash down with at least 2 buckets of water.

So the data all areas as one continuous piece with out carriage returns. I have thousands of lines of data, so doing this manually would take days.