C csv delimeter Oct 26, 2009 #1 How do I save an excel as a csv while specifying something other than comma as a delimeter?
J Jacob Skaria Oct 26, 2009 #2 You can have a VBA solution to save with the delimiter you like. Another way is to save as tab delimited (.txt) or .csv and then open the file in notepad or a text editor and replace tab/comma with the delimiter of your wish. If this post helps click Yes
You can have a VBA solution to save with the delimiter you like. Another way is to save as tab delimited (.txt) or .csv and then open the file in notepad or a text editor and replace tab/comma with the delimiter of your wish. If this post helps click Yes
D Dave Peterson Oct 26, 2009 #3 You could change your list separator to the character that you want in windows control panel (regional settings applet). Remember to change it back. You may not like what happens to other stuff--like formulas in excel.
You could change your list separator to the character that you want in windows control panel (regional settings applet). Remember to change it back. You may not like what happens to other stuff--like formulas in excel.
G Gord Dibben Oct 26, 2009 #4 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 On Mon, 26 Oct 2009 07:05:01 -0700, csv delimeter <csv
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 On Mon, 26 Oct 2009 07:05:01 -0700, csv delimeter <csv
