Cleaning up an imported txt file

Thanks for the tip. I scrambled the VINS on the original post but I have changed this now to be xxxxxxxxxx. How can I attach a excel file, do I need to zip it?

Thanks.
Yes, Excel files need to be zipped. Also, if you are using 2007, saving and posting your file in an earlier format increases the number of people who can look at the fie.

Attached is the spreadsheet that contains the example file. Hopefully somebody can help me with the code.
Thanks