I am running excel and would like to export my file as a .scsv (semi-colon separated values) sheet instead of a .csv. Is there any way to do this?
ps. I can't do a .csv and search and replace commas with semi-colons because the fields contain commas already.
Best Answer
How about doing Tab Delimited and replacing the tabs with semi-colons?
In excel: File -> Save As -> in Format select "Tab Delimited Text (.txt)" then his save.
Open the file in notepad and open the replace window. Since you can't tab directly into this window, copy a tab from your document and then paste it into the Find box and put your ; into the replace box. Then replace all.
I assume this would work because it is very rare to have tabs within an excel document.