Delimiter in CSV files

[Guest]

Hi,

I want to know HOW TO change the file delimiter in CSV for Excel 2002.

Thanks,

Marc.

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/textfiles.html#differentdelimiter

 

[Guest]

Thanks for the Quick reply.

Unfortunatly I don't know I thing about MACROS in Excel. I read your
solution, looks good, but I guess I have to put that in a macro!!!

If so, can you tell how to create a macro. I have to use that macro in lots
of spreadsheet, is a MACRO propriatary to one spreadsheet??

Thanks,

Marc.

 

[Peo Sjoblom]

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Dave Peterson]

How about changing your windows regional setting list separator?

Remember to change it back when you're done (and to toggle it when you need it
the next time).

 

[Guest]

I am not a pro at this stuff, but I did notice that in excel 2000, when I
went to the drop down menu:
Data, Text to Columns...
Then I went through the process of a csv import and selected the settings I
normally use, (I always us comma delimeter not tab), and at the last step I
hit cancel, that setting became the default setting.