#1
|
|||
|
|||
Convert .txt to .xls
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 |
#2
|
|||
|
|||
.
Excel includes a Text To Columns feature on the DATA TAB. Experiment with that as it should attain the goal you are seeking. |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to convert table to convert table into iCalendar file? | Weboh | Word VBA | 5 | 12-10-2016 03:07 PM |
How to convert 8 1/2 x 11 to A4 | GrantSaw | Word | 3 | 01-28-2015 11:04 AM |
How do you convert to .MOV? | pmr8888 | PowerPoint | 0 | 11-30-2011 04:32 PM |
How to convert PDF to jpg? | gonner | Outlook | 1 | 10-28-2011 06:25 PM |
convert | golden039 | Word | 0 | 08-16-2009 05:48 PM |