text file to xls format

[srisurya]

I have multiple text files(delimited) that I need to transfer to sheets
in a single excel file I was wondering, if I could put all files in a
single text file in a format that could be understood by excel and sort
it out into various pages.

 

[mudraker]

The would open the txt files in Excel then right click on the sheet tab
and create a copy of the sheet into your master workbook.

If you do this often or if you have a large number of txt files then I
would suggest a macro to do it for you