Hi, thanks to everyone reply to my previous request for help, i can now automatically paste multiple .txt files into excel, but my next question is how do i make sure all the text from one .txt file pastes into only one field.

thank you in advance