No,,,
What I'm trying to say is that once you pasted the data in text editor, read the data directly from the text file and process before output to Excel by vba.
So can you upload the text file here?