Bill Sharpe wrote:
Export as a csv file. Open file in Notepad and replace commas with
semi-colons.
Works fine unless you have commas in your cells.

Bill

"capitan" wrote in message
...
Hello all. We have the need to export a file from excel to a semicolon
delimited text file. Is there a way to do this from Excel directly? If
not, does anyone have any other suggestions? TIA for your help.



Thanks Bill. You read my mind, because that is exactly what we are
doing with it now. My hope is to automate the process. Thanks anyway.