convert notepad .txt to xp .xl
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.
"Gary''s Student" wrote:
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
--
Gary''s Student - gsnu200771
"Dave" wrote:
I have several large files in notepad text format that I need to convert to
.xl in .csv format. (Windows xp) Can u help?
|