Convert text file from SAP to Excel format table

[jakobt]

Downloading a text file from SAP. I want to have it in a table format in Excel.

I tried text to column with either space or | as deliminiter, but I get no where near a table format.

How can I convert a textfile in format attached to an excel format (Table).

 

[Marc L]

​

As obviously this text file is not a delimited format but use a fix format !​

So with the right answers to the Import Wizard you can easily import any kind of text file …​