How to save a worksheet into a ";" sperated text file

D

Dave Peterson

You could change windows list separator to semicolon and then save as a .csv
file.

Windows start button
settings|control panel|regional settings|number tab
List separator: (near the bottom)

Remember that this is a windows setting and may affect other programs.

Or you could use a macro that Earl Kiosterud wrote. It's at:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

It has a lot of options that you may like.


Daphne wrote:
 
Top