Exporting data in Excel 2000

  • Thread starter Thread starter Mike S. Nowostawsky
  • Start date Start date
M

Mike S. Nowostawsky

I used to be able to export data in different types of delimited text format
from within other excel versions, but now it only allows me to 'Save as' a
text file and I am limited to a TAB delimited file.
Is there a way to specify which delimiter I can have in the saved/exported
text file? I can't find anything under the Data menu (where it used to be, I
believe). Now you can only import a delimited file in multiple formats
there.

thx.
--

===============================================
Mike S. Nowostawsky:
Email: (e-mail address removed), (e-mail address removed)
Home Page: http://www3.sympatico.ca/mikenowo/
Lachine (Montreal), Quebec, Canada
 
You could change the windows setting to change the list separator:

Windows start button|settings|control panel|regional settings applet
Number tab|Near the bottom

Remember that this is a windows setting, so it could affect other programs, too.


But you may want to try using a macro to write the file:

Here's a couple of links that may give you an idea:

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

Earl Kiosterud's:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

=========
I still get a bunch of SaveAs options in xl2002--a few .txt and .prn.

You may want to post back with your version of excel if you don't find them.
 
nevermind. I just had to save it as an .CSV file... used to do that, just
forgot how.
--

===============================================
Mike S. Nowostawsky:
Email: (e-mail address removed), (e-mail address removed)
Home Page: http://www3.sympatico.ca/mikenowo/
Lachine (Montreal), Quebec, Canada
 
Back
Top