View Single Post
 
Old 10-23-2013, 10:41 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I agree with Pecoflyer that a copy of the text file you're importing would make it a lot clearer. But my guess is that you're using the wrong option to start with. In step 1 of the Text-Import wizard, go with fixed-width fields rather than delimited. Judging from your screen shots, all the fields in the report are in the same text positions; once you've imported the results, just delete the rows that contain the page and column headers and that should leave you the data you want. Of course, you'll probably still have to do some formatting, but it's closer.
Reply With Quote