convert notepad .txt to xp .xl

D

Dave

I have several large files in notepad text format that I need to convert to
..xl in .csv format. (Windows xp) Can u help?
 
G

Gary''s Student

From Excel:

Data > Import External Ddata > Import Data

then use the dialog to specify the .txt file and use the Import Wizard to
"columnate" the data correctly.

Finally SaveAs .csv
 
J

JLatham

IF!! the content of the .txt file is as you'd expect to see it when examining
a .csv file in Notepad, you may be able to get away with simply changing the
filename from AFile.txt to AFile.csv

If you're lucky, that is. If not, then go with Gary's solution.
 
Top