Forum Discussion
Excel Save as Unicode Text (with line breaks) and then trying to open the Unicode Text file in Excel
I don't understand how the Text Import Wizard handle line feeds within a column. Trying to create files that are accepted by Excel but it seems a bit harder than expected. A simple test that, in ...
That is not entierly true. When you save the text file where there are line feeds in a cell, Excel will (normally) add the text qualifier ("). In a cell the line break also differ slightly, only LF is used. A 'real' row break is both CR+LF. You can see this in the picture that is attached to the thread where you have the screendumps from Excel before export, after import, and from Notepad++ (to see the characters you don't see in Notepad and which file encoding that is used).
G_u_s_t_a_v Sorry for misleading Information above
I dint know about this
But I would surely love to learn from you how to see the screendumps