import multiple .txt files into one excel sheet with selected column

xxd001

New Member
Joined
Jun 10, 2016
Messages
6
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!
 
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
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!

No hugs required :)

I'm glad it worked and I was able to help. I learned something new myself too :cool:
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top