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.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.