Search/Replace to Insert CR (Alt-Enter) into text

[Martha]

I want to Find and Replace a sequence of text
characters, "||", with Alt-Enter (carriage return). The
Find/Replace does not allow me to enter Alt-Enter or Char
(10) or 0x0A as the replacement characters.
The reason I am stuck doing this is because I am pulling
data, via a SELECT/REPLACE statement from an Oracle
database that contains multi-line text (Chr(10)). No
matter what I try in SQLPLUS, it corrupts other fields
unless I replace it with a regular Ascii character
sequence such as "||". I have tried double quoting and
other format tricks, but nothing allows me to build the
csv file properly to Excel can load it, if it contains the
Alt-Enter characters. Therefore, I finally converted it
to ascii characters and want to manually convert it back
after I open up my Excel file by using Search/Replace.

 

[Peo Sjoblom]

Try to hold down alt while typing 010 on the numpad in the replace with box,
then release alt,
you won't see anything but it works

 

[Peo Sjoblom]

Formula? Use edit>replace and copy over "||" (w/o quotes) to the replace
what box
and then in the replace with box use the method I described. If you are
using a formula
you can use CHAR(10)

 

[Guest]

Thanks, for some reason, the first time I tried your
suggestion, as directed below, the Search/Replace kept
giving me a Formula too long error. I reopened the file
and tried again, and this time it behaved as you indicate
it should.
THANKS AGAIN
Martha