- File origin set to 'Windows (ANSI)' or '65001: Unicode (UTF-8)' or '1252: Western European (Windows)' (tested a few more with the same result).- Original data type set to 'Delimited',.Change file type to 'All files' or 'Text files'.Select File\Save As and change Save as type to 'Unicode Text (*.txt)'.Add the text 'Row 1', press Alt+Enter to add a line feed within the cell and then add the text 'Row 2' as a second row in B2.Add the text 'HeaderAA' in A1 and 'HeaderBB' in B1.Open Excel and create a blank workbook.Trying to create files that are accepted by Excel but it seems a bit harder than expected.Ī simple test that, in my mind, should work but doesn't. I don't understand how the Text Import Wizard handle line feeds within a column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |