View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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?