Semicolon Delimter

[tylerpat7]

I need to save an excel spreadsheet to a semicolon delimited text file. Is there a way to do this? In the save as options I have noticed you can save tab delimited and comma delimited, but no semicolon.

 

[Greg Truby]

Do you know enough about VBA to be able to adapt Oorang's code on this thread? If you edit the third arg in the REPLACE() function to be a semicolon instead of Chr(44) that should give you a workable solution.