Hi I am Arun From Cochin
How to convert a text file to excel with Macro in rows and columns
I attached the text file
Please help to step by step procedure
Hi I am Arun From Cochin
How to convert a text file to excel with Macro in rows and columns
I attached the text file
Please help to step by step procedure
To attach a file Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window. Remember to press "upload" and then "close the window" buttons
Best Regards,
Kaper
Hi Sorry
File attached
Still can't see it :-(
I attached one text file
The file has well defined, althought quite complex structure. Better suited to human reading than for machine.
To import it into excel, in a form which could be further processed, probably dedicated VBA code shall be prepared.
Just a slight warming here - It will be rather time-consuming task (code preparation).
Or use a program like Monarch to extract the data for you, that's what I typically do for data structured like this.
majority of it can be done with
text import wizard
https://support.office.com/en-us/art...f-f78bafe41857
http://www.jkp-ads.com/Articles/importtext.asp
use the default fixed width (instead of delimited)
some editing would be required afterwards on certain rows this can be manually or you can do with via macro
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks