I need to save an excel spreadsheet to a csv file and not have extra commas at the end.
G Guest Jan 20, 2005 #1 I need to save an excel spreadsheet to a csv file and not have extra commas at the end.
J JE McGimpsey Jan 20, 2005 #2 one way: Use the CharacterSV() macro found at http://www.mcgimpsey.com/excel/textfiles.html Use a comma as the delimiter. if you're unfamiliar with macros, check out David McRitchie's "Getting Started with Macros" at http://www.mvps.org/dmcritchie/excel/getstarted.htm
one way: Use the CharacterSV() macro found at http://www.mcgimpsey.com/excel/textfiles.html Use a comma as the delimiter. if you're unfamiliar with macros, check out David McRitchie's "Getting Started with Macros" at http://www.mvps.org/dmcritchie/excel/getstarted.htm