Convert Notepad to Excel

I am trying to convert a report in notepad to excel. I have attached the actual report and a sample of the excel file format that it needs to be in. If anyone can guide me through this I would really appreciate it.

Thanks

Unfortunately all I can say is Good Luck!! This is very difficult due to the formatting of the text file, and that it will vary substantially between files. In all honesty I would say that you would have more luck copy and pasting

Can you request the data in any other format? Anything would be better than this

Your thinking the same way that I did. I asked all those questions and got no success. I did find a thread that talks about doing it but I just need some clarification and guidance to do it, because I am no VB expert...lol! I have attached the link to the thread if you want to take a look at the request and the code that they gave to resolve the issue. Can you let me know if this is something that I can use:

http://www.excelforum.com/excel-prog...-to-excel.html

It is almost like the situation is identical.