save excel spreadsheet as a csv file
I need to save an excel spreadsheet to a csv file and not have extra commas
at the end. |
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 In article , thelma wrote: I need to save an excel spreadsheet to a csv file and not have extra commas at the end. |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com