Semi-Colon delimited text files from Excel...

[DeutchBose]

Is there any simple way to create a semi-colon delimited text file from an excel spreadsheet?

 

[passinthru]

Depends on your definition of "simple", I guess! I don't know of a way I'd call simple. If you have to do this repeatedly, it's probably time for some VBA code. (Which, to some of the gurus on this board, IS simple!)

If it's a once or twice thing, I suggest saving it as CSV, then open it up in Word and use Search and Replace to make the commas into semi-colons. Then save as text.