Dear Experts,
I need help in importing data from a text file into excel then splitting the data into different columns.
Here is a copy of the sample data called "EPN.TXT".
Many thanks for your help.
Regards,
Kay
Dear Experts,
I need help in importing data from a text file into excel then splitting the data into different columns.
Here is a copy of the sample data called "EPN.TXT".
Many thanks for your help.
Regards,
Kay
It's without order and composition. Is this a text-based screenshot ?
Is the system from which it's generated can not create any ordered/sorted txt file with separators ?
What is what in this txt file ?
Give an example of the result of the data you would like to obtain.
They are separate. The items around the "Page Total" should be ignored. Many thanks.
P.S. I was away from the office for several weeks and did not check on the forum.. I am sorry for the late response.
Hi !
Attach at least a source text file and a filled expected result workbook according to this text file …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks