MrExcel Publishing
Your One Stop for Excel Tips & Solutions

comma delimited text files in excell


Posted by C.F. Jackson on March 05, 2001 10:50 AM

Would appreciate information on how to save an excell (*.xls) file as a comma delimited text (*txt) file. It appears my option is a tab delimited file.

Any info will be appreciated

Thanks,

C. Jackson


Posted by Dave Hawley on March 05, 2001 11:03 AM


Have you tried saving it as a *.csv file ?

Dave
OzGrid Business Applications

Posted by C. F. Jackson on March 05, 2001 12:19 PM


Posted by C. F. Jackson on March 05, 2001 12:23 PM

I need to import it into a program that will only accect the *txt format.

Thanks

Posted by Aladin Akyurek on March 05, 2001 1:14 PM

Maybe a bit more work, but you can read in a tab delimited file in a text editor (e.g., Editeur on Windows, Jedit on MacOS) and replace tabs with commas.