Copy from txt, paste into word and then into excel

[c.vaibhav]

Hi,

I have some data in a particular format in notepad (Source code of a webpage) which when I copy into excel does not come up the way it should. It might look the same, but when I copy from excel back into notepad it gives double quotes where it shouldnt.
However when I do it by using word as a translator then it does it perfect. i.e. when I copy notepad file into word then copy the word file into excel, the result is as desired.

Is there any macro that would do this automatically. I will just have to select the notepad file and the data will be pasted into excel in the same format. The macro would simply copy the data into word first and then the word data will be copied into excel. If you know of codes that does the conversion please share.

Or also, if there is some way to import the notepad data into excel by keeping the formatting intact would be great. You might not see the harm in formatting in excel but when you re-copy the excel data into notepad, it gives all the unnecessary double quotes.

Thanks,
Vaibhav

[arlu1201]

Please attach a sample file and we can assist you easily.