![Excel text import wizard not opening](https://kumkoniak.com/46.jpg)
![excel text import wizard not opening excel text import wizard not opening](https://www.automateexcel.com/excel/wp-content/uploads/2021/05/Convert-Step3.jpg)
![excel text import wizard not opening excel text import wizard not opening](https://www.addictivetips.com/app/uploads/2010/02/textimportwizard.jpg)
- 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.
![excel text import wizard not opening excel text import wizard not opening](https://blogs.sap.com/wp-content/uploads/2018/04/pic1-4.png)
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.
![Excel text import wizard not opening](https://kumkoniak.com/46.jpg)