How to copy text file into new excel

[Chen-Jim (Chenjinhua)]

Hi,
I want to copy text file all data into excel file , pls help me . Thanks!

Test.txt (555.5 KB)

[Rajeswari24 (Rajeswari Punnamaraju)]

Hi @Chen-Jim,

Please go through this thread.

Copy notepad text to excel?

hi all, im trying to paste a text file onto an excel workbook. The text file looks like this: [Capture2] It should look something like this: [1] However, when i try to use read text file and then write cell, it looks like this: [Capture] Are there any other methods that would help in this situation? Any help will be appreciated, thanks. Text file: intructions.txt (607 Bytes)

Hope this helps

Regards,
Rajeswari

[Chen-Jim (Chenjinhua)]

Thank you very much !