You need to remove unwanted chars and fix the end of line points.
What unwanted characters? He said nothing about unwanted characters.
Excel needs the end of line char to start the next row.
No, it does not.
Excel can parse data by using the Text-to-Columns command. Numerous references on parsing data with Excel can be found by searching on a phrase such as
how to parse data in excel. Here's one reference:
http://www.addictivetips.com/microsoft-office/excel-2010-split-column-data-into-two-parse-cells/ Although it demonstrates parsing into two columns, more columns can be easily done using the same procedure.
I see one variation in the data shown in your PDF file. The first row begins with a " followed by the first long number. The last char in that row is a - . The next row begins with 2, and then all subsequent rows start with a single digit number. In other words, I get the impression all rows should end in a single digit number following the last - in the group of numbers and then a " as the last char of every line.
Actually, all the quotation marks are not needed when parsing in Excel. So, removing them from the file before starting the parsing procedure would work best, I believe. To remove the quotation marks, you could open the file in WordPad and use the Replace command to replace them with nothing. Then, save the file and import it into Excel, invoking the Text-to-Columns command during the import, or copy the corrected data in WordPad and paste in to Excel as you simultaneously parse.
