I have over 100 text files and each of them has two columns of numbers, the columns are separated by space, they are stored under the same folder. The final goal is to import all of the text file into a single excelsheet, and i want only the second column of each text file showed up in the excelsheet. Is that possible to do? I have no knowledge about VBA or macro. please help! Thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
import multiple .txt files into one excel sheet with selected column
It works perfectly for me!!!! you are so amazing!! I want to give you a hug. This is exactly what i want. Thank you very much for your quick reply and perfect solution. This solves my big problem, and it is just on time. now i can start analyze my data and turn them in tomorrow. I hope you have a good week!
Upvote
0
No hugs required
I'm glad it worked and I was able to help. I learned something new myself too
Upvote
0
Similar threads
- Solved
- Question
