Thanks! Yes, you are right! I just noticed that in my file as well.
There is a “Wrap text” option in Excel (under formatting cell) that controls this.
I think that needs to be done separately, in Excel, after the export is completed from Toad (I don’t see an option to control this from Toad). But that’s still good for my purpose.
From: John Dorlon [mailto:email@example.com]
Sent: Thursday, August 17, 2017 11:48 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Export from Toad into Excel is not preserving the “new line” characters inside a field
RE: Export from Toad into Excel is not preserving the “new line” characters inside a field
Reply by John Dorlon
I tested chr(13) || chr(10) before my first reply and it worked with the “Excel Instance” export option.
With the “Excel File” option - at first it looks like it doesn’t work, but then when I double-click a cell in Excel, the line feed suddenly appears.
I wonder if there is some setting in Excel that affects this.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.