Hi,

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

Thanks,

Marc.

See

http://www.mcgimpsey.com/excel/textf...erentdelimiter

In article ,
LAF wrote:

Hi,

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

Thanks,

Marc.

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.

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/textf...erentdelimiter

In article ,
LAF wrote:

Hi,

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

Thanks,

Marc.

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


--
Regards,

Peo Sjoblom



"LAF" wrote in message
...
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.

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/textf...erentdelimiter

In article ,
LAF wrote:

Hi,

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

Thanks,

Marc.

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).

LAF wrote:

Hi,

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

Thanks,

Marc.

--

Dave Peterson

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.


"LAF" wrote:

Hi,

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

Thanks,

Marc.