Help!
-
Here's the problem: I have raw data (from a mainframe) in the form of a text file and its also already in tabular form with a title centered on top and everything. These numbers are normally inputted manually on Excel. How do I get that info from the text file automated so it is put into Excel nicely? Do I keep the text file as a text file or do i want to change it into CSV file? What is the easiest way to go about this?
-
Here's the problem: I have raw data (from a mainframe) in the form of a text file and its also already in tabular form with a title centered on top and everything. These numbers are normally inputted manually on Excel. How do I get that info from the text file automated so it is put into Excel nicely? Do I keep the text file as a text file or do i want to change it into CSV file? What is the easiest way to go about this?
Try just opening it in Excel. Excel's Text importer is pretty good at dealing with tab-delimited files.