Bill,

A problem with this approach is that if semicolons are the delimiter, then
the field should have quote marks around it if a semicolon appears in the
data. The program writing the file needs to put the delimiters in, so it
knows when to add the quote marks. Otherwise, the program reading the file
can get messed up if semicolons are in the data. More at
http://www.smokeylake.com/excel/textfiles.htm.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

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