hello.
I wish to convert a txt file that is saved down in my folder into a .xls file.
Before I do this however I need to sort by columns and I wish to sort by using the delimited file type - Other | key.
Once created as a .xls file.
I need to import the file into my workbook under worksheet "US Pennies"
Any ideas how I can do this?
File path the txt file is save under is
N/My Documents.
I wish to convert a txt file that is saved down in my folder into a .xls file.
Before I do this however I need to sort by columns and I wish to sort by using the delimited file type - Other | key.
Once created as a .xls file.
I need to import the file into my workbook under worksheet "US Pennies"
Any ideas how I can do this?
File path the txt file is save under is
N/My Documents.