ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convert notepad .txt to xp .xl (https://www.excelbanter.com/excel-discussion-misc-queries/178293-convert-notepad-txt-xp-xl.html)

Dave

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

Gary''s Student

convert notepad .txt to xp .xl
 
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?


JLatham

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?



All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com