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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,102,292
Messages
5,485,978
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top