Would like to save Excel spreadsheet as a CSV file using the delimiter "~"
G Gord Dibben Feb 11, 2009 #2 CSV means Comma Separated Values so if saved with "~" de-limiter it could not be a CSV What you do is save as a *.TXT file. Earl Kiosterud's free TEXTWRITE.xls workbook will do what you want. http://www.smokeylake.com/excel/text_write_program.htm Gord Dibben MS Excel MVP
CSV means Comma Separated Values so if saved with "~" de-limiter it could not be a CSV What you do is save as a *.TXT file. Earl Kiosterud's free TEXTWRITE.xls workbook will do what you want. http://www.smokeylake.com/excel/text_write_program.htm Gord Dibben MS Excel MVP
D Dave Peterson Feb 12, 2009 #3 Maybe you can temporarily change the windows list separator (under the control panel|regional settings) to that tilde character. Do your saveAs and then change the list separator back to what you had before.
Maybe you can temporarily change the windows list separator (under the control panel|regional settings) to that tilde character. Do your saveAs and then change the list separator back to what you had before.
