Hello,
I have a .txt file that’s exported when a report is ran.
I’m needing to convert this .txt file into .xls and
I need to make sure the data gets converted into
Certain lines and columns during the conversion
Process.

If I submitted a example of the txt and of what the xls file
needs to look like after the conversion, could you please help
Me to code the conversion?



Thanks

.
Excel includes a Text To Columns feature on the DATA TAB.

Experiment with that as it should attain the goal you are seeking.

as Logit says Text to columes is brilliant for a number of things, and very intuitive.


But feel free to upload,. happy to have a look