I have a problem at work, a convert text file into Excel file, which a lot to solve search did not find the solution: -



It will show the problem with the pictures to bring the issue: -

First: This file format script I'm working on an old system which is the DOS




Second: Log on to the Excel program and data list, and then chose from text button

Then the rest of the steps

















And finally the final shape is totally inconsistent




The question here is what is the solution to this problem?

Without seeing the raw data, difficult to say.
And if you use "space" as delimiter ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I used "space" as delimiter However it gives me the same result

Posting a sample file might help

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I've explained Pictures
As I can not raise the working files

I agree with Pecoflyer that a copy of the text file you're importing would make it a lot clearer. But my guess is that you're using the wrong option to start with. In step 1 of the Text-Import wizard, go with fixed-width fields rather than delimited. Judging from your screen shots, all the fields in the report are in the same text positions; once you've imported the results, just delete the rows that contain the page and column headers and that should leave you the data you want. Of course, you'll probably still have to do some formatting, but it's closer.

Thank you, but there is a definite way automatic without interference

Any reason why you answer my posts using a bold and large font?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I'm not sure what you meant. It sounds like you might be saying there's a definite need for this to be all automatic—but in that case you'd be asking about VBA rather than using the text-import wizard. Can you try to say that again, using other words?

What's your native language, by the way? Maybe you could explain in that language, and I could figure it out by reading that.

nothing my friend

With all due respect, as we do not know each other, please refrain from calling me " friend". Thank you As this thread is clearly leading nowhere, I leave it to others to help you further. Good luck

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Don't quit now, mradmin; take a look at my last post and see whether you can answer my questions there.

No one can of experts to solve my problem as I have explained