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!