Text Into Excel

G

G3£Wh\)zZ@

I have a text file list of uk music charts for 2004
In this format data on seperate rows

Nelly & Christina Aguilera
Tilt Ya Head Back
28 Nov
5

I could do with importing it all into excel so it ends up with data in
seperate columns,
I know that copy ,paste special,transpose would do this for individual bits
of info
But is it possible to do all of the text file in one go without having to
copy n paste each one.

Tia

And Season Greetings
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Populating a Text Field with a value in an Excel Sheet 0
Linking data in MS Word into Excel 5
Text To Columns then insert rows 7
nk into onenote 2016 paragraph from excel 2016 cell 0
Number stored as text 4
Copy and Paste Special in Excel #REF error 1
Making report in WORD file by using information from Pivot table 3

Top