Txt file convert to .xls

kris01

New Member
Joined
May 29, 2019
Messages
2
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.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,099,892
Messages
5,471,331
Members
406,757
Latest member
dizzane

This Week's Hot Topics

Top