I have an extract from a Lotus Notes Database. When entering data into the
database, we used the enter key to separate paragraphs. When this data is
placed into Excel, the carriage returns appear as either a BEL character of 7
or a DEL character of 127. Not quite sure, but it shows up as a square.

I would like to remove all these characters and replace them with a space.
If I use the Clean function, all of the characters (spaces) are removed, but
this does not leave any spaces so words and paragrahs then become combined.
I have tried a combination of the clean and substitute functions without any
success.