What .TXT representation of linebreaks within cells will be correctly imported?

When I have a line break like this (created by my program, or as in this example by Excel itself):

the Excel import wizard misinterprets it like this:

How can I avoid this failure?

The advice in Importing CSV with line breaks in Excel 2007 did not help.

Workarounds by post-import editing are unacceptable.

EDIT: Dragging the .TXT into Excel gives a different failure:

EDIT: Untrue. Expanding the row reveals success:

EDIT: EDIT: Replacing Tab with comma does not give success from File|Open or drag.

ANSWER summary: The given representation works - provided the .TXT file import is done by dragging not File|Open.


I created your file locally (thanks for hex dump!) and when I Import or File->Open the file I get the same results. However, if I just drag the file into Excel I actually get the expected line breaks. I then created a similar file directly in Excel and saved it as a tab delimited file and repeated the same process with the same results. So the fact that Excel won't correctly import a file that it creates leads me to believe that this isn't possible.

The next thing that I tried was replacing your tab with a comma and this actually worked for the File->Open scenario but not for the Import.

My guess is that Excel assumes that if you are "importing" text then it assumes it isn't in a correct and known format already. So I would suggest just sticking to CSV best practices.

Need Your Help

Starting activity on dialog after button clicked

java android button android-studio dialog

I'm a noob in Android Studio and now i'm stuck creating my app.I created a Floating action button in my main activity and clicking on it i'd like to display a dialog asking to user what to do.In this

Incorrect Query

java mysql phpmyadmin

I have following two query both are same but differs only in structure.