G
Guest
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.
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.