carriage returns in text

Giganews Newsgroups
Subject: carriage returns in text
Posted by:  Janet (janet.oldak…@motorola.com)
Date: Wed, 1 Oct 2003

I am exporting data from another database through (TOAD)
and putting into an XLS format. Everything comes over fine
except for a long field and it contains vertical
rectangles in the body of the text. It looks to be
everywhere where there was a hard return. How do I get rid
of these symbols? Replace doesn't work because it does not
recognize it as a character. Turning outline symbols off
doesn't work either. Any ideas?

Replies