import data from multiple text files in excel
i need to import data from multiple text files (.txt or .rpt or .lst) into excel and then split the same in different columns. i am doing it manually with a specified set of rules and process flow. i understand it could be automated and